Macro Export to PDF on MAC

[99problems]

Hello,

I have this macro on my Mac Excel worksheet and when i try to export my sheets into PDF, i am getting an error message "Print Error while printing"

Please Login or Register  to view this content.

Can someone please tell me how to fix this?

Thanks

[humdingaling]

is that actually the path for your desktop?
C:\Users\my\Desktop\data\mydashboard.pdf

[99problems]

is that actually the path for your desktop?
C:\Users\my\Desktop\data\mydashboard.pdf

yes. It is correct.

[mikerickson]

That does not look like a Mac file path.

But I did find this link. Ron DeBruin's Function MakePDF uses AppleScript, since Excel for Mac's vba doesn't work reliably

http://www.rondebruin.nl/mac/mac005.htm

[99problems]

That does not look like a Mac file path.

But I did find this link. Ron DeBruin's Function MakePDF uses AppleScript, since Excel for Mac's vba doesn't work reliably

http://www.rondebruin.nl/mac/mac005.htm

Yes, i changed it to the correct the path in my script.

And Ron DeBruin's Function only saves the pdf to the application folder. Is there any other working script?

thanks

[mikerickson]

I haven't looked at DeBruin's code in detail, but if his location of the PDF could be altered to suit your needs.