Macros blocked by antivirus

[Sebastien]

Hello All !

I wish send an excel file with macros to a customer of mine.
His antivirus blocks my excel file, because it believes that my excel file
is a virus (macro virus).

How can we workaround that problem ?

- write a macro which removes all macros, in order to send the file per
e-mail ?

Your meaning about that ?

Seb

 

[A.W.J. Ales]

Sebastien,

No guarantee, but I sometimes can solve this by encoding the file (UUE or
MIME).
Also quite often : Is the macro protected ? If so : some Viruscheckers do
react only on the fact that the VBA code is.

A last possibility could be to copy the modules and put them (as text) on a
"normal" worksheet, remove the modules, send the file and at the receiving
address copy theat text again and put it back in modules.

(If you go this way : Do check that the file doesn't "say" it still has VBA
code even if all the modules are emptied or removed, this sometimes
happens).


Anahow : succes!

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Frank Kabel]

Hi
for removing the macros automatically before sending them have a look
at Ron de Bruin's Sendmail Add-in:
http://www.rondebruin.nl/sendmail.htm

 

[Arvi Laanemets]

Hi

Send them packed.
Btw. Some MS Office updates did set Outlook to clear automatically any (not
sure about, which ones exatly, but some of them: *.exe, *.xls or *.mdb)
'dangerous' attachments from incoming post.

 

[Tim Zych]

What virus protection is being used?
If Norton AntiVirus, it has a search feature called Bloodhound which is
probably causing this.
If so, one solution is to shuffle around the code that is causing it. Are
there macros that add modules, delete code lines, add code lines or
otherwise interact with the VBE?