Z
Zinzah
I am trying to VBA code this into Excel 2003. I seem to be having issues with
the command line switches. They work find if I run it from START/RUN, but I
cannot seem to get VBA to make it happen:
Private Sub CommandButton5_Click()
filenumber = InputBox(picnumber)
Shell ("C:\Program Files\Common Files\Microsoft
Shared\MODI\11.0\MSPview.EXE" -r "\\Centralsrv1\Marketng\Marketing
Specialists\Scans\" & Filenumber & " 001.tif")
End Sub
Does anyone know how to make the 'standard' command line parameters work in
VBA XL2003?
Thanks for any help in advance!!
the command line switches. They work find if I run it from START/RUN, but I
cannot seem to get VBA to make it happen:
Private Sub CommandButton5_Click()
filenumber = InputBox(picnumber)
Shell ("C:\Program Files\Common Files\Microsoft
Shared\MODI\11.0\MSPview.EXE" -r "\\Centralsrv1\Marketng\Marketing
Specialists\Scans\" & Filenumber & " 001.tif")
End Sub
Does anyone know how to make the 'standard' command line parameters work in
VBA XL2003?
Thanks for any help in advance!!