Adapting this Save as PDF code to Mac

[MagnusNovak]

Hi guys,

I've been using the following VBA code to run a "save as PDF" macro but it seems that the code won't run on mac computers:

Please Login or Register  to view this content.

Do you know what generates the error and what I should replace it with?

Thank you

[mjr veverka]

But what error, what description, what number ?
Even people who know mac may have difficulty identifying with such a scant, small description.
I do not know so much about mac, but I have such comments:

Please Login or Register  to view this content.

[Pepe Le Mokko]

Please explain what "doesn't work" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?

[jindon]

Please Login or Register  to view this content.

That's a Windows path separator, so change it to

Please Login or Register  to view this content.

[MagnusNovak]

Sorry for this very late answer. Jindon, I've made the change you suggested but the error remains the same. I turned off the errHandler to see the real error and the message is the following:
"Compile error in hidden module: "Module1". This error commonly occurs when code is incompatible with the version, platform, or architecture of this application"

Module1 is the module with the code that I mentioned in my first post.

Similarly, my other sub to print (not save as pdf) also doesn't work on Mac, based on the following code:

Please Login or Register  to view this content.

The error message being in this case: "Run-Time error '1004': PrintPreview method of Worksheet class failed"

If anyone has ideas, I'm listening! Appreciate your help on that, thanks again