G
Guest
I am currently working in access, using a form, and I would like to create a
button which opens a specific spreadsheet in a specific excel workbook.
Currently I am using the following code to open the workbook:
Dim stAppName As String
stAppName = "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE
N:\SMDiv\Test\Reporting.xls\vehicle charts"
Call shell(stAppName, 1)
Exit_Command189_Click:
Exit Sub
Err_Command189_Click:
MsgBox Err.Description
Resume Exit_Command189_Click
End Sub
If there is a better way to do this, I would appreciate that as well
Thank you
button which opens a specific spreadsheet in a specific excel workbook.
Currently I am using the following code to open the workbook:
Dim stAppName As String
stAppName = "C:\Program Files\Microsoft Office\Office10\EXCEL.EXE
N:\SMDiv\Test\Reporting.xls\vehicle charts"
Call shell(stAppName, 1)
Exit_Command189_Click:
Exit Sub
Err_Command189_Click:
MsgBox Err.Description
Resume Exit_Command189_Click
End Sub
If there is a better way to do this, I would appreciate that as well
Thank you