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

Excel 2003 - Save as dialog box 9
Show the Paste Names dialog via code 3
1004: Activate method of Range class failed 1
Run-time-error 1004 "ListIndex method of listbox class failed" 1
CopyPicture method of range class failed using RangeName 5
Find the Error in my Code Please 4
how to diaplay compare merge dialog box 1
Error 1004 - Autofill 3

Top