Shell Command

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

I am trying to open crystal reports and launch the report
I created. The following launches the program but how do I
launch my report?


Shell("C:\Program Files\Seagate Software\Crystal
Reports\crw32.exe")

My report is in this directory.
("M:\RMAG\Access 2000\ff_unique_visit 2004.rpt")

THANKS for any suggestions
 
I tried this with notepad and it worked, even with spaces in the path name.
Whether it will work or not with Crystal Reports, I don't know. It will
depend on whether or not Crystal Reports will accept the parameter on its
command line.

Shell "C:\Program Files\Seagate Software\Crystal Reports\crw32.exe
M:\RMAG\Access 2000\ff_unique_visit 2004.rpt"
 
I am not sure what to do? Do I put that in notepad and
call notepad I tried this in access but get compile error
line number or statement or end statement.

Dim cry
cry =Shell ("C:\Program Files\Seagate Software\Crystal
Reports\crw32.exe"
M:\RMAG\Access 2000\ff_unique_visit 2004.rpt")
 
I was simply commenting that I used Notepad as a test since I don't have
Crystal Reports. Try the entire statement with both command lines within ONE
set of quotes with a space between the command lines.

Dim cry
cry =Shell ("C:\Program Files\Seagate Software\Crystal
Reports\crw32.exe M:\RMAG\Access 2000\ff_unique_visit 2004.rpt")
 
Back
Top