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
Copy FROM - TO Object/Block variable not set 6
Convert A1 value to a sheet name and copy to it 2
Duplicating worksheet based on range and changing worksheet name 3
Excel 2013 Merge Data 2
loop to copy paste 5
Open four Wbooks, copy four columns from each to Master Wbook 16

Top