Is there any command in VBA for opening the file once it has been created?There is an option for opening the file in the standard pdf program in the PDF Creator printer dialog. Is this option programmable in Excel VBA?
Best regards
Zeb
I found the simple solution myself!
I'm using PDF Professional 7 for viewing and editing PDF Files so you have to replace it with your program, of course!
Public Sub OpenPDFViewer()
Dim x As Variant
Dim Path As String
Dim File As String
Path = "C:\\Program Files\uance\\PDF Professional 7\\bin\\PDFPlus.exe"
File = "D:\\Trader\\PDFScreen.pdf"
x = Shell(Path + " " + File, vbNormalFocus)
End Sub
Good luck out there
Zeb