Opening Excel file from access

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

Guest

i have a spreadsheet (DATA.xls) that is linked to a table (SummaryTable). I
am trying to write VB code to open the spreadsheet for viewing from the
database after the table has been updated and am struggling on how to open
the excel file. Thanks in advance for any assistance.
 
i have a spreadsheet (DATA.xls) that is linked to a table (SummaryTable). I
am trying to write VB code to open the spreadsheet for viewing from the
database after the table has been updated and am struggling on how to open
the excel file. Thanks in advance for any assistance.
Click to expand...

Application.FollowHyperlink "c:\FolderName\Data.xls"
will get you there.
 
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

Record-Locking remains open after closing 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Data Transfer Issue (strange situation) 1
Linked Excel spreadsheet to be used as table 3
A2003 bringing in data from an Excel spreadsheet 1
Refresh and run Excel macro 7
How to cause a spreadsheet (Excel) to run from an Access Macro 4
Code required to close a form & hyperlink ... 4

Back
Top