Sub OpenPDF_test()Ĭonst XCviewPath = "C:\Program Files\Tracker Software\PDF Editor\PDFXCview.exe"Ĭonst pdfFileName = "C:\myPath\myPDFfileName.pdf"ĭebug.Print XCviewPath & " """ & pdfFileName & """" You'd need to specify the path/filename of your PDF, and you may need to confirm the location of PDFXCview.exe on your machine. You have to replace appPath with your XChange viewer path.īelow is an example of how to call the application using Shell. OpenFile = Shell(appPath & " " & myFile, vbNormalFocus) Sub Export()ĪppPath = "C:\Program Files (x86)\Adobe\Reader 11.0\Reader\AcroRd32.exe" Sub to save as pdf then open in a program. OpenFile = Shell(openPath, vbNormalFocus) Sub OpenPDFbyAdobeReader()ĮxePath = "C:\Program Files (x86)\Adobe\Reader 11.0\Reader\AcroRd32.exe"įilePath = "E:\CyberArk\DNA_Datasheet.pdf" The directory is: C:\Program Files\Tracker Software\PDF ViewerĪs you mentioned you already managed to export to PDF, so try below code to open the PDF file in Adobe Reader In case of PDF XChange Viewer put XChange Viewer exe file path in the code. What should i do to open the PDF in PDFXChange Viewer. Title:="Select Folder and FileName to save")ĭisclaimer i copied the codes from somewhere online because i wanted to allow users to name the file, select where they save it.
Now Im having difficulties trying to have the PDF automatically open in PDF XChange Viewer instead of Adobe Reader. Hi guys i'm brand new to coding but i have somehow (haha) managed to export my excel into PDF.
0 kommentar(er)
