Import from Excel

[sumdumgai]

Is it possible to import data into Access using VBA from an Excel workbook that is available but has not been saved to a folder or desktop; i.e., the workbook was opened as an email attachment but never saved? Thanks. If I try to create an import specification by manually import the workbook, the browsing window doesn't allow anything but a file location specification (e.g. C:\folder\subfolder).

 

[Rkay]

When you open an attachment, a copy is put under the temporary internet files in a hidden OLK folder

 

[sumdumgai]

Thanks for you help.