mickyflash
Board Regular
- Joined
- Jan 29, 2009
- Messages
- 77
Hello Everyone
I hope you all had a great Christmas. I was very lucky to get a new macbook, however now I am getting some issues with my vba code that was working great with windows.
I used this code to print my excel worksheet as a pdf, using CutePdf printer driver set to a default size of 900mm x 910mm.
However I am struggling to find a Mac driver, that can do the same and print outside the preset page sizes. and am unable to set any of the default pages at the desired print size.
I think I can use the ExportAsFixedFormat to dictate the page size but I am struggling to get it working. Does anyone have any ideas?
I hope you all had a great Christmas. I was very lucky to get a new macbook, however now I am getting some issues with my vba code that was working great with windows.
I used this code to print my excel worksheet as a pdf, using CutePdf printer driver set to a default size of 900mm x 910mm.
VBA Code:
Sub PDF()
'
' PDF Macro
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
"/Users/micksolecki/Downloads/FF/MFF 2.0/Clubs/ACD.pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
End Sub
However I am struggling to find a Mac driver, that can do the same and print outside the preset page sizes. and am unable to set any of the default pages at the desired print size.
I think I can use the ExportAsFixedFormat to dictate the page size but I am struggling to get it working. Does anyone have any ideas?