Error with Save As PDF macro in Mac but not in Windows

The primary user of the file is on a mac running Excel 2011 and he gets a runtime error
run-time error 1004: method ExportAsFixedFormat of object worksheet failed.

I'm not sure why it's not working on the Mac as it works on Windows. Hoping someone can help. Thanks so much!

Please Login or Register  to view this content.

Hi gazellette and welcome to ExcelForum,

Thank you for using 'Code Tags'.

Please Login or Register  to view this content.

I do not use a MAC, but my speculation is that the item in red may be the cause of your problems, because the path separator in Windows is '\' and the path separator in MAC is ':'. I suggest you start with something like the sample Macro above. Start with fName as a file Name only like 'abc.pdf' and start building from there.

After that is successful, try using GetSaveAsFilename(), and see if it fails, see what the difference is between the hard coded file name and the file name you got using GetSaveAsFilename().

The following Windows debugging tips probably work on the MAC too:
a. Press 'F8' to single step (goes into subroutines and functions).
b. Press SHIFT 'F8' to single step OVER subroutines and functions.
c. Press CTRL 'F8' to stop at the line where the cursor is.
d. 'Left Click' the margin to the left of a line to set (or clear) a BREAKPOINT.
e. Press CTRL 'G' to open the IMMEDIATE WINDOW. 'debug.print' statements send their
output to the IMMEDIATE WINDOW.
f. Select View > Locals to see all variables while debugging.
g. To automatically set a BREAKPOINT at a certain location put in the line:
'Debug.Assert False'
h. To conditionally set a BREAKPOINT at a certain location put in lines similar to:
if i >= 20 and xTV20 > 99.56 then
Debug.Assert False
endif
i. A variable value will be displayed by putting the cursor over the variable name.

To manually set a breakpoint, see http://www.wiseowl.co.uk/blog/s196/breakpoints.htm

I hope this helps.

Lewis

Hi all -

Just wanted to share the very roundabout solution we came up with for this - it only works with El Capital and Office for Mac 2016 so we had to update the user. GetSaveASFileName does not appear to work well on the Mac platform and often fails so we had to come up with a different way of asking the user for a file name and location.
Thank you Lewis for the suggestion to start from a file name and build from there and the debugging tips!!

Please Login or Register  to view this content.