Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Location
    Chicago, Illinois, USA
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    .xls to .pdf (Excel 2000 (9.0.6926 SP-3))

    I have multiple Excel files (.xls) that I need to convert on a weekly basis to Acrobat 5.0 (.pdf). Acrobat has a nice "Watch File" function, taking .ps and converting them to .pdf automatically. Anyone know how to automate multiple .xls to .pdf? Thanks!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: .xls to .pdf (Excel 2000 (9.0.6926 SP-3))

    <P ID="edit" class=small>(Edited by sdckapr on 26-Jul-04 13:21. Added an additional one)</P>Do these posts and their threads help:
    <post#=315236>post 315236</post#>
    <post#=362199>post 362199</post#>

    or you might even try posting a question at Adobe's Support since this seems to be more of an adobe question rather than an excel question.

    Steve
    PS Forgot this one: <post#=26059>post 26059</post#>

  3. #3
    New Lounger
    Join Date
    Jul 2004
    Location
    Chicago, Illinois, USA
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: .xls to .pdf (Excel 2000 (9.0.6926 SP-3))

    I tried Adobe Support and believe it or not, not one response! Post 315236 (particularly 315255 with attachment, together with 315271) is exactly what I need. But where in 315255 do I add the code from 315271? Do I delete anything? Then, how do I run it when I'm ready? I know nothing about VB. Thanks so much for your help.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: .xls to .pdf (Excel 2000 (9.0.6926 SP-3))

    These lines:
    <pre>filename = activeworkbook.name
    filename = left(filename, len(filename)-4)&".pdf"</pre>


    Could go anywhere before the printout line. Choose the file name as you desire.

    Something like the line:
    Worksheets(1).PrintOut ActivePrinter:="Acrobat Distiller", printtofile:=True, collate:=True, prttofilename:=FileName

    would go as additional parameters for the PrintOut line in your macro

    To run the code go to tools- macro - macros and select it to run.
    I don't use distiller or adobe so I can not test it. You will have to let us know if it does what you want or what you need to be modified.

    Steve

Posting Permissions

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