Save sheet as PDF

  • Hi Guys

    I need a little help please, I have the following code:

    This works fine, except ideally I would like to save all the files into one PDF document with the name being Mth (eg Jan-18)

    I guess something like copy values to a new sheets each time and then some kind of array for those new sheets.

    There will only ever be 4 sheets in the array.


  • Hi Mar070503,
    try this

    [COLOR=#FF0000]ActiveWorkbook[/COLOR].ExportAsFixedFormat Type:=xlTypePDF, Filename:=...

    instead of

    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=...

    Oh, no, I misunderstood the question

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!