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

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

jas wrote:

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

--

Dave Peterson