Query excel temproary file from Access

R

Robert

I' need to develop an Access app that is able to query a temporary XL file
from within Access (without saving the XL file). The user has one of
several HTML links to CSV/XLS files that they can choose from within their
web browser. The Access application knows the name of the files these links
create, but not the temporary folder that Excel is currently using to store
these files.

Does anyone know of a way to get this environment variable from Excel via
Access?

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access-Excel Automation 1
Access #Error & Excel Pivot 0
Access-Excel Automation 1
Excel won't go away 10
Access 2007/XP - Excel 2007/XP 1
transferspreadsheet method but set query criteria from vba? 1
Can Access create Excel VBA 3
How can you generate an Excel file from a query that has parameter 4

Top