call shell function

[Guest]

how does access2003 know where to find the "Excel " program from in the code
below ?

If Me.List23 = "Project8" Then
' Excel Application on Project 8
Call Shell("Excel ""C:\Program Files\Croftonite Systems\Intime
Export\ExcelData\Project8.xls""", 1)
End If

 

[Alex Dybenko]

Hi,
perhaps it in the PATH list. Anyway - better approach - is to use
shellexecute API:
http://maug.pointltd.com/access/Queries/TipDetail.asp?TipID=5

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[John Nurick]

It doesn't. It simply passes the command line to Windows.

 

[Guest]

thanks Alex but managed to get over problem using call hyperlink

 

[Guest]

thanks John

It doesn't. It simply passes the command line to Windows.