VBA Save entire sheet to pdf. Prompt for location

[ScousePete]

I'd like to have the entire sheet saved to pdf, with a prompt for the user to select the location.

I have found similar scripts that save the sheet, but not one that prompts for location

Thanks

 

[ScousePete]

Unfortunately not. But thank you for trying.

 

[Fluff]

Hopefully somebody with a Mac will step in & help.

 

[Jim Gordon]

Hi

You can make an input box to get the file name, then use code below to save the file.

You can learn how to add a userform and controls to the userform here:
VBA Express : Excel - Programmatically Add a UserForm

Use a variable for the file name

    ChDir "/Users/UserName/Desktop/"
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
        FileName, Quality:=xlQualityMinimum, _
        IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
        False