Query excel temproary file from Access

[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.

 

[PieterLinden via AccessMonster.com]

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.

You can't link to an Excel file that hasnt been saved, AFAIK. You could
write it to a folder somewhere and then delete it after querying by using the
KILL statement in VBA.

 

[ryguy7272]

Just save the file and use a technique similar to this:
http://www.rondebruin.nl/accessexcel.htm