J
John Cello
Give this a try. Make it the OnClick event procedure of
your command button.
Tested on Access 2003, Win XPPro
Function runexcel()
On Error GoTo runexcel_Err
' In the Call Shell section, put the path to Excel.exe
and the path to your .xlt
Call Shell("C:\Program Files\Microsoft Office\OFFICE11
\excel.exe ""C:\1\Book1.xlt""", 1)
runexcel_Exit:
Exit Function
runexcel_Err:
MsgBox Error$
Resume runexcel_Exit
End Function
Hope this helps.
John Cello
John Cello Consulting
Communications For Business
www.johncelloconsulting.com
your command button.
Tested on Access 2003, Win XPPro
Function runexcel()
On Error GoTo runexcel_Err
' In the Call Shell section, put the path to Excel.exe
and the path to your .xlt
Call Shell("C:\Program Files\Microsoft Office\OFFICE11
\excel.exe ""C:\1\Book1.xlt""", 1)
runexcel_Exit:
Exit Function
runexcel_Err:
MsgBox Error$
Resume runexcel_Exit
End Function
Hope this helps.
John Cello
John Cello Consulting
Communications For Business
www.johncelloconsulting.com