#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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!!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"