Runtime ERROR '1004': Show method of dialog class failed

[steve_aero]

I am new to excel. When I create a button and associate a macro, when envoked, brings up a outlook email with the current file attached. This works fine on my pc. But when I post it to my web server and access through browser, I get the above error. The macro is as following:
Sub FileSendTo()
'
' FileSendTo Macro

Application.Dialogs(xlDialogSendMail).Show

End Sub

 

[Haluk]

you will get the same error message when you run the code,

Application.Dialogs(xlDialogOverlayChartType).Show

while there isn't any chart on your worksheet.

Your problem is very similar to that.

 

[steve_aero]

I had a friend of mine access it through the browser and it worked fine for him, with out any problems. He is running win2000, IE 5.5 and Excel 2002.
I get the error and I am running NT, excel 2000.
Any thoughts?

 

[steve_aero]

Sorry, I have Excel 97 not 2000.

 

[steve_aero]

Any ideas on this error?

 

[Bargos]

Hi,

Did anyone manage to solve this? Im getting it now...