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
 
You must log in or register to reply here.

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

Excel Excel spreadsheets opening at top instead of bottom. 4
Export Data from Queries in Access 2007 to Excel Spreadsheet 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Export to Pocket Excel 1
Excel Spreadsheets keep moving 0
Excel Access - importing an excel spreadsheet 0
Format Excel columns with VB code. 3
Best Tool to Repair Corrupted PDF Files 0

Back
Top