ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SendMail error (https://www.excelbanter.com/excel-programming/340501-sendmail-error.html)

brucez

SendMail error
 

I have a spreadsheet that works fine if opened locally (C: drive).
If it is opened in Internet Explorer (http://www.xx.com/book1.xls), it
generates the following error: Run-time error '1004': Show method of
Dialog class failed.

The only line of code in the Button_Click event is:
Application.Dialogs(xlDialogSendMail).Show

Any help would be greatly appreciated.

Bruce


--
brucez
------------------------------------------------------------------------
brucez's Profile: http://www.excelforum.com/member.php...o&userid=27372
View this thread: http://www.excelforum.com/showthread...hreadid=468871



All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com