Can Access open an Excel spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After an export of a query to Excel, can I have Access immediately open the
Excel spreadsheet (on top) so the user can see it?, i.e. to the user, it
would look seamless.

Thanks,
prairie smoke
 
Assuming that the path to the Excel workbook is in the variable
strFilespec, you can use

Application.FollowHyperlink strFilespec, , True
 
Back
Top