Excel Automatic e-mail sending in Excel Embedded IE

J

jtm7699

Joined
Apr 13, 2010
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Automatic e-mail sending in Excel 1
VBA problems with excel embedded in IE 1
Gridlines Printing from embedded Excel File in Word 2007 3
Sending mail from Excel with CDO by Ron de Bruin 4
refresh data in embedded excel objects 1
In Presentation Mode - want automatic update of links from Excel f 2
loop through distribution group (and potentially, embedded DGs) by 1
Embedded Excel 2003 Worksheet in PowerPoint 2003 2

Top