ExportAsFixedFormat issue?

[mickyflash]

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.
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?

 

[Joe4]

Duplicate to: Adjusting VBA Code for mac (ExportAsFixedFormat) problem

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.