Software

Are able to send between yourselves but not to a third person on a different network, I would check that the different network is not filtering or blocking. VBA is generally defaulted as a bad thing as so is frequently blocked.

this user is being blocked by a firewall that blocks vba macros in smtp traffic. Is there a way to circumvent that? Or how can I go about removing the macros in the excel spreadsheet?

The receiving company may not block zip files- you could try re-packaging the file as a zip.

I don't think that you will get past the filter as is. I will also warn you that if they are blocking VB, they may also block zip files- lots of bad stuff was sent out in zips.

I assume that the macros are there because they are needed to perform some kind of calculation. I don't think there is a global way to turn them all off. I think that you have to get into the macro editor and kill them there.

But try this- have your user send to an internet mail account. It may work because the target LAN wouldn't see the traffic as smtp. Even if the destination doesn't allow web mail in the office, the recipient could access the file from home and drop it on a USB stick or disk.

If this is a file that needs to go back and forth a lot, the two end users should consider another transmission method or remove the VBS.

Good luck!

are they on the same LAN? If so, the email to you would never hit your firewall in the first place.

Get yourself a yahoo account and send it to that.

Anyone that would accept a excel/word file with VBS Macros in it is soon to lose their data because of viruses, and I can't blame the admin at the other end if he is blocking you.

No they are on completely different networks. However I have read where sonic firewalls block vba macros through smtp traffic. However the user claims to be able to send through hotmail. I cannot send through gmail. I have not tried yahoo. I wonder why that is