|
-
Apr 8th, 2003, 04:15 PM
#1
Thread Starter
Junior Member
code to run file from user's CD drive
I have an Excel file and iview32.exe I am going to put on a CD.
I use this code to find what drive user utilizes (and it works):
DriveID = Application.ActiveWorkbook.Path
While testing from my HD, I have this code to activate iview32.exe (and it works):
Shell "D:/Program Files\Irfanview\i_view32.exe /slideshow=C:\a.txt", vbNormalFocus
After I put all on CD, I will need to modify above to reflect path on CD like so:
Shell DriveID (User's CD Drive)& ":" & "\" (Concatenate this)Irfanview\iview32.exe /slideshow=C:\a.txt", vbNormalFocus (Path on CD)
Tried it, but can't get parens () and Quotes " and & in right places.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|