Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2003

    Question 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

    Dim fs
    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")
    End If
    Set fso = Nothing

    i need help ASAP thanks
    Last edited by cajunmike; 11-06-03 at 17:01.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts