ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   mspview.exe (https://www.excelbanter.com/excel-programming/399854-mspview-exe.html)

Zinzah

mspview.exe
 
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!!


All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com