ClarityNDT
New Member
- Joined
- Mar 25, 2020
- Messages
- 12
- Office Version
- 2013
- Platform
- Windows
As title,
We have a master template that users have a controlled copy of. when complete, the user has a save and publish button they press which auto saves the document and creates a PDF
The issue I have is some users, even when using the same machine as another user (obviously their own profile) have an issue where the pages are published with the row margins all over the place.
This obviously points to a print setup error, but I can't seem to figure out where to change anything that actually works
Examples attached.
Any assistance greatly appreciated!
We have a master template that users have a controlled copy of. when complete, the user has a save and publish button they press which auto saves the document and creates a PDF
Code:
'now create the pdf. the Filename range selects the cell contents as the filename, note this is an absolute path and extension in this case.
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=Range("V7").Value, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
The issue I have is some users, even when using the same machine as another user (obviously their own profile) have an issue where the pages are published with the row margins all over the place.
This obviously points to a print setup error, but I can't seem to figure out where to change anything that actually works
Examples attached.
Any assistance greatly appreciated!