Show method of dialog class failed

J

jas

While trying to save a excel file which is not linked or grouped error
msg as shown below is got

With Application.Dialogs(xlDialogSaveAs)

.Show

End With



Error:



Run time error '1004'

Show method of dialog class failed
Please suggest a resolution to overcome this error
 
D

Dave Peterson

That snippet of code worked fine for me in a simple test.

Maybe the error is caused by something you didn't share.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error when copying entire row! 5
"Run-time error '1004' 5
Help with error on PasteSpecial 2
Select method failed - Error 400 2
1004: Activate method of Range class failed 1
Run-time-error 1004 "ListIndex method of listbox class failed" 1
Application.top=0 fails 3
Show the Paste Names dialog via code 3

Top