ActiveSheet ExportAsFixedFormat Type:=xlTypePDF

A simple VBA macro program script will be able to open or display a dialog window, asking the use...

I want the code to save the copy in the same directory as the original document a folder called "...

I am a bit new to VBA coding but have managed to create a macro ... through all worksheets and sa...

The VBA code below saves a specified chart as a PDF. ... worksheets and save as individual PDF in...

I am trying to create individual pdf file for three active sheets (Report1, Report2 and Report3) ...