Posts by luddite

    Re: Convert Excel To PDF

    I tried the code exchanging PDFCreator with Jaws PDF Creator, but it doesnt like Application.ActivePrinter, I think this might be a Mac thing.

    Re: Convert Excel To PDF

    I have recorded a macro of the process, but it only shows this code:

    ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1
    ActiveWindow.SelectedSheets.PrintOut Copies:=1

    which is file_print but missing the save as pdf.
    The macro does work, but if I save and reopen the workbook it no longer works.

    Re: Convert Excel To PDF

    Hi Gollem

    I dont think I do have any software apart from the in built mac stuff. What could I download that would help? I do have adobe reader but thats about it.

    Is it possible to convert an xls workbook to pdf and save it within a beforesave sub. I have managed to cobble together a piece of code that saves using cell values as the filename, but I also need another copy saved as a pdf. I am using excel 2004 on a mac. As you can save file as pdf manually with File_Print_Save as PDF I thought it would be easy. Perhaps I need a later copy of excel. If anyone can help I would be very grateful.