Unanswered: excel conversion to pdf file Help ASAP
I'm using macro's to open and copy a new month workbook. then i convert to pdf for archiving to folder. i want to be able to run a macro to search archive for file and open with Adobe Acrobat from the excel workbook. How do you write open with this application? here is what i got so far
Set fs = CreateObject("Scripting.FileSystemObject")
If fs.FileExists("C:\CORE FIELD\PLATFORM 1\2003\JANURARY.pdf") = True Then
Application.DisplayAlerts = False
ChDir "C:\CORE FIELD\PLATFORM 1\2003"
Workbooks.Open Filename:="C:\CORE FIELD\PLATFORM 1\2003\JANURARY.pdf"
Answer = MsgBox("File Not Found In Archive", vbExlamation, "Core Archive")
Set fso = Nothing