Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWorkbook.SendMail and IE - odd problem
I added a button to an existing Excel sheet so the user can email the sheet
to me. It works fine if run from Excel. However, the user accesses the sheet from an ASP menu, delivered via Internet Explorer. When the user clicks the button, the ActiveWorkbook.SendMail command works fine. But any VB command after the SendMail fails. For example, Sub crct() ActiveWorkbook.SendMail _ , ", _ Subject:="correction requested" Range("d5:e7").ClearContents Range("d2:d3").ClearContents End Sub The Range command gives me "Method Range of object _Global failed". I get some type of error for ANY command executed after the SendMail command, but only if run via IE. Any ideas? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveWorkbook.SendMail not working | Excel Programming | |||
Alert message during Activeworkbook.sendmail | Excel Programming | |||
ActiveWorkbook.SendMail | Excel Programming | |||
ActiveWorkbook.SendMail Security Warning | Excel Programming | |||
Activeworkbook.sendmail | Excel Programming |