G
Guest
what is the visual basics code to create a command button to open an excel
file?
file?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allan Murphy
Use the shell command
Sub open_excel()
Dim app_name As String
app_name = "C:\Program Files\Microsoft Office\OFFICE11\excel.exe
d:\common\abc.xls"
Call Shell(app_name, 1)
End Sub
C:\Program Files\Microsoft Office\OFFICE11\excel.exe is where the excel.exe
file is located
d:\common\abc.xls is the name of the excel file to open.
Alternatively you could use a hyperlink, look up the help file for this
item.
Sub open_excel()
Dim app_name As String
app_name = "C:\Program Files\Microsoft Office\OFFICE11\excel.exe
d:\common\abc.xls"
Call Shell(app_name, 1)
End Sub
C:\Program Files\Microsoft Office\OFFICE11\excel.exe is where the excel.exe
file is located
d:\common\abc.xls is the name of the excel file to open.
Alternatively you could use a hyperlink, look up the help file for this
item.
G
Guest
Dear,
If you go to support.microsoft.com and search there for "automation" and
"excel" for Access, you'll find very useful examples how to imbed Excel in
Acces.
Dries
If you go to support.microsoft.com and search there for "automation" and
"excel" for Access, you'll find very useful examples how to imbed Excel in
Acces.
Dries