Open external application file with parameter using VBA

[Guest]

I have had some great help on my earlier question on the subject of opening an external application file using VBA. I am now faced with a new problem and would appreciate some help.

When I run Shell "MyComputer\Myfolder\AcroRd32.exe C:\Myfile.pdf" it works fine.

When I assign say Selectfile="C:\Myfile.pdf" and run Shell "MyComputer\Myfolder\AcroRd32.exe Selectfile", an error message is displayed by Acrobat - "There was an error opening this document. The file does not exist.

 

[Vasant Nanavati]

You are mixing strings and variables. Try (untested):

"MyComputer\Myfolder\AcroRd32.exe " & Selectfile

Note the space at the end of the first substring.

--

Vasant

I have had some great help on my earlier question on the subject of

opening an external application file using VBA. I am now faced with a new
problem and would appreciate some help.

When I run Shell "MyComputer\Myfolder\AcroRd32.exe C:\Myfile.pdf" it works fine.

When I assign say Selectfile="C:\Myfile.pdf" and run Shell

"MyComputer\Myfolder\AcroRd32.exe Selectfile", an error message is displayed
by Acrobat - "There was an error opening this document. The file does not
exist."

 

[Guest]

Thanks Vasant. Sorry there was an error in my question. I actually ran this VBA code Shell "MyComputer\Myfolder\AcroRd32.exe " & Selectfile , where Selectfile="C:\Myfile.pdf" but got an error message.

 

[Vasant Nanavati]

Francis, this worked for me from the Immediate Window:

strFile = "C:\Documents and Settings\Administrator\My
Documents\Vasant\IndustryBrains\IndustryBrains.pdf":Shell "C:\Program
Files\Adobe\Acrobat 5.0\Acrobat\Acrobat.exe " & strFile

Watch the line wrap.

I'm not sure why you are using My Computer instead of the drive letter.
Perhaps that is the problem.

--

Vasant

Thanks Vasant. Sorry there was an error in my question. I actually ran

this VBA code Shell "MyComputer\Myfolder\AcroRd32.exe " & Selectfile , where
Selectfile="C:\Myfile.pdf" but got an error message.

 

[Guest]

Thank you very much for all your help, Vasant. Now it works perfectly.