Set document scale for a published pdf worksheet

[Brian F]

At the end of a VBA macro I publish a pdf version of the Worksheet and save that pdf in a specified location using the code below. [I use this code rather than "Print" because it allows me to specify the save location, which I have been told I can't do with the Print command.] The problem is that the resulting PDF is too large a scale (100%). Is there a way I can tell the code to publish the document at 50% scale?

ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=Application.DefaultFilePath & "\" & NuFileName, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False

 

[Andrew Poulsom]

The ExportAsFixedFormat method uses the settings in Page Setup so adjust those first.

 

[Brian F]

Thank you for pointing me in the right direction. With a bit of research I made this work.