PC Review


Reply
Thread Tools Rate Thread

Automatic e-mail sending in Excel Embedded IE

 
 
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


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