remove macros

[JT in VN]

We have a virus like macro in many Excel files. We are unable to remove them
manually ('delete' button grayed out).

One solution was to copy the worksheets into a new file then proceed to
remove book.xlt in the xlstart folder. However there are many files and this
would be a daunting task.

1) Is it possible to search for Excel files that has the particular macros
(ie. based on creator name of macro)?

Alternatively I am also downloading software called 'Macro Remover' that is
supposed to remove all macros. However I am afraid that this may remove the
'good' macros.

Suggestion welcomed.

Justin

 

[g-]

Yes, it is possible to write a routine that will open Excel files, scan for
a particular macro/module and erase said macro/module.

Off the top of my head, it can be done in 2 ways.

A) Scan of the hard drive for all XLS files and then perform said function
on any found XLS files (potentially a LOT of computing time).

B) A Macro that sits on every computer that examines any workbook opened
for said "virus macro" and intercept/removes it before control is passed
back to the user. More information would be needed about this "virus macro"
before this could be written.

Can contact me if you need additional help.

g-
(e-mail address removed)
___________________________________

Need holiday money. Got any jobs, big or small, drop me a line! Thanks!