Runapp macro

[bkirsch]

I understand how to use a runapp maro to open files excel windows etc...



Is there a macro I can run to open an illustrator file??

I tried a runapp with the following command

"C:\Program Files\Adobe\Adobe Illustrator CS2\Adobe Illustrator CS2" "\\Ushccharfs01\groupdata\Sponsorship and Sales\Database\Blank_Term Sheet.pdf"

but I am getting an error because it is not an ms-dos application....

[June7]

Is Adobe Illustrator your default program for pdf files? If so, just open the pdf file.

http://www.ehow.com/how_7277774_open-pdf-file-vba.html

[bkirsch]

Adobe Acrobat is my default for opening PDF's. I need to open this particular pdf in illustrator so it can be edited...

[June7]

I don't use macos, only VBA. Try this:

Sub OpenPDF()
Dim A As String
Dim P As String
Dim r As Integer
A = Chr(34) & "C:\your path to app\AdobeIllustratorCS2.exe " & Chr(34)
P = Chr(34) & "C:\your path to file folder\filename.pdf" & Chr(34)
r = Shell(A & P, vbNormalFocus)
End Sub