PDA

View Full Version : How to show 'Save As' dialog box?



accell
10-06-2014, 05:03 PM
Hey All,

The last line of my macro (that has been running smooth on PCs) brings up the save as dialog bog: 'Application.Dialogs(xlDialogSaveAs).Show'.
This command causes the macro to fail when ran on Macs. Does anyone know what the issue is or what a workaround is so that I can display the save as dialog box?

Error Reads: "Method 'Show' of object 'Dialog' failed"
Thanks!