Run shell command in VBA
Posted on 2008-11-19
I have tested the below code running from a macro in excel and it works fine
Shell "rundll32.exe C:\WINDOWS\System32\shimgvw.dll,ImageView_Fullscreen \\path"
But instead of opening fax viewer i want to open document imaging. I tried this but it doesn't work. I know document imaging is mspview.exe but don't know if thats what i need.
Shell "rundll32.exe C:\Program Files\Common Files\Microsoft Shared\MSPaper\MSPVIEW.EXE, \\path"
Also instead of path I want the value of the active cell in excel, which is the path.
Any help would be appreciated as I have tried loads of variations