Copy a worksheet that can be attached to a web-based internet system

M

Michael Lanier

I have designed a workbook so that based upon the following macro, a
designated worksheet ("Sheet1") will be copied and sent to Outlook
where it is mailed.

Private Sub Worksheet_Activate()
ActiveWorkbook.Worksheets("Sheet1").Copy
ActiveWorkbook.SendMail Worksheets("Sheet1").Range("A1"),
Worksheets("Sheet1").Range("A2")
ActiveWorkbook.Close False
'A1 = User's mail | A2 = User's confirmation
End Sub

If I attempt to email a workbook on a computer that does not have
Outlook (Mail, Express), this macro obviously debugs. Therefore, I
need to be able to make a copy that can be easily accessed, renamed
and attached to web-based systems such as hotmail and yahoo. I would
appreciate any help fashioning a macro that will accomplish that
goal. Thanks.

Michael
 
M

Michael Lanier

Thanks Ron. I can tell it will be a bit of a struggle, but I think I
can plow through. Thanks again.

Michael
 

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

E-mail a worksheet, then auto open another and do the same by valueof a cell 2
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Duplicating worksheet based on range and changing worksheet name 3
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Convert A1 value to a sheet name and copy to it 2
Create Workbooks and Copy Template Worksheet to those Workbooks 12
Workbook jumps to Sheet1, cell A1, regardless of where it was whenlast saved 3
Worksheet range copy 3

Top