Opening Excel file from access

B

brad

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.
 
F

fredg

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.
 
Top