Automatic e-mail sending in Excel Embedded IE

jtm7699

New Member

Join Date: Apr 2010

Posts: 1

13th Apr 2010

When using Ron de Bruin CDO_Mail_Workbook to email workbook from Excel, all works great when opening the file in Excel. However we have the need to post the file on the intranet and in some cases it will open embedded in IE. At this point we get the following error:

1004 Method 'SaveCopyAs' of object '_Workbook' failed.

It appears that since it is embedded the VBA does not know the ActiveWorkbook information.

Thanks
Josh

« How to reduce calculation time of the complicated sumproduct formulas? | Hyperlink to pdf »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatic e-mail sending in Excel	efe_aras	Windows Vista	1	3rd Feb 2010 07:20 AM
sending automatic email with VBA-Excel in Vista OS and Windows Mail	Alain Bernard	Microsoft Excel Programming	3	21st Feb 2008 04:51 PM
Sending Embedded Objects by Mail.	=?Utf-8?B?VmFpYmhhdiBKb3NoaQ==?=	Microsoft Access VBA Modules	4	5th Oct 2005 07:20 AM
sending smtp mail with embedded images	Ersin Gençtürk	Microsoft ASP .NET	0	6th Apr 2005 01:08 PM
sending smtp mail with embedded images	Ersin Gençtürk	Microsoft ASP .NET	3	4th Apr 2005 06:55 PM