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
ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=Application.DefaultFilePath & "\" & NuFileName, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False