Some firewalls have an antivurus scanner that will remove all email attachments that have VBA macros embedded. I know Sonicwall firewalls have this capability.
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.
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
Collapse -
Error 552 MS-Office file containing VBA macros found
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Has anyone seen this error
552 MS-Office file containing VBA macros found inside of the email
He can send the attachment to me which means that the proble is not coming from within their network.
I have tested this on our other network and through a gmail account and got the same response.
He claims he was able to send through a web based email but I'm not sure about that.
Thanks for any help on this!