Excel Outlook VB

[Paul Dennis]

Hi, I currently have an Excel book then when a button is pressed the vb
behind it saves the book and then emails it via Outlook.

My problem is the company firewall prevents it being sent. Can't change the
firewall rules, hence is there a way around it, i.e.

disable or delete the vb during the save?

or do I need rather than save the book to save the relevant sheet to another
book - don't know the syntax

????

 

[Joel]

Your problem could be a couple of different situations.

1) The firewall is doesn't allow .xls files to be attached to an e-mail

Solutions: Send the data as a table. Or rename the xls file to slx. Tell
the people who receive the e-mail to rename the file before using the file.
Most filewalls look only for specific extensions on files and block these
extensions. Attaching an unknown extension usually doesn't get blocked.
2) The firewall doesn't allow .xls files with macros to be sent. Remove
the macros before sending the file.

 

[Tom Ogilvy]

Activesheet.copy

creates a copy of the sheet in a new workbook.

then you can work with ActiveWorkbook.