Application.Dialogs(xlDialogSaveAs).Show

Question

Hi all

I have a problem with Application.Dialogs(xlDialogSaveAs).Show in my macro.

After this line there is also other code in the same macro.

In Windows it wait until you use cancel or save in the dialog before it run the other code but

on a Mac it not wait. As a workaround I can use getsaveasfilename but I hope that there is a fix.

Thanks for reading

Answer 1

I gave up on the dialog and create a function for getsaveasfilename

I add it on my Mc page

http://www.rondebruin.nl/mac.htm#GetSaveAsFileName

Commants are very welcome

Answer 2

I use applescript to display certain dialogs

Let MyDir = MacScript("Choose Folder")

Answer 3

Hi Bob

I know that I can use getsaveasfilename, see text in my posting

>As a workaround I can use getsaveasfilename but I hope that there is a fix.

But they are not the same, and the point is that there is a lot of code using it that will not work on a Mac now so it is good to see if there is a way to use it.

Answer 4

I already answerd you on the MVP forum. Use application.getsaveasfilename instead.

Answer 5

Update: it seems to work when you run the code in the VBA editor on a Mac

But not when you run it from a Button/Menu or with Alt-F8