Robin Hammond: That looks nicely thorough, but a bit more involved than
I had in mind.
Gary's student: I like your suggestion. Easy and straightforward.
macropod: You're right to a certain extent. If the file is zipped, it
is allowed in.

Thanks to all for your input.
Emilio



macropod wrote:
Hi Emilio,

If your firewall/antivirus is rejecting *incoming* files with macros, then you're not going to be able to get around it with another
macro, since you can't test the file before your firewall/antivirus has had a go at it.

Cheers

--
macropod
[MVP - Microsoft Word]


wrote in message ps.com...
| Hello all,
|
| I'm not so familiar with Excel macro programming (as is perhaps evident
| by my question).
|
| Is there a way to determine which Excel files have macros?
|
| The reason for this request is that our firewall/antivirus appears to
| be rejecting emails that have Excel attachments - only certain ones,
| though. I'm thinking that the reason some Excel files are being
| rejected is because they have a macro (or macros).
|
| Thanks for your input,
| Emilio
|