Open an excel file from Access

[robojeff]

Is there an easy way in Access 2003 to open an excel file while giving the user the typical Windows file search/open screen to allow them to choose the file that they wish to open?

Thanks

 

[DPlank]

Can't you use the FileSystemObject to create an instance of a new Excel.Application and tell it to load the file directly?



Cheers,
Dave

"Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software." <-- Me

For all your testing needs: Forum1393

 

[robojeff]

Thanks for the tip... I will search on FileSystemObject to see how to use it with my access script

 

[steph22]

Is this what you're looking for?

Dim strDlg As String
      strDlg = "Select the excel file"
      varFileName = adhGetExcelDataPath(strDlg)

varFileName = the path to the excel file chosen by the user.

Hope this helps!
Stephanie