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