Open Excel

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

Guest

What is the best way to open a specific excel file from an access form using
code. I cannot use the hyperlink, I would like the Excel file to open from my
code.

Thank you,
 
the simplest way is the Shell code on the click event of a command button:
Dim FName As String
FName = "C:\my stuff\Test.xls"
Call Shell("Excel " & Chr$(34) & FName & Chr$(34), vbMaximizedFocus)

Damon
 
What is the best way to open a specific excel file from an access form using
code. I cannot use the hyperlink, I would like the Excel file to open from my
code.

Thank you,
Click to expand...

Is:

Application.FollowHyperlink "C:\MyFolder\MySpreadsheet.xls"

the same as using hyperlink?
Or is it code?
 
Back
Top