Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Word / May 2008



Tip: Looking for answers? Try searching our database.

Strip macros from documents en masse?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SidneySM - 07 May 2008 18:33 GMT
I'm dealing with a few rather large and annoying macro virus
infestations, and am looking for a tool that I can throw a folder of
Word documents at and have any macros stripped from all of them. Does
anything like this exist? Thanks.
Jonathan West - 07 May 2008 18:56 GMT
> I'm dealing with a few rather large and annoying macro virus
> infestations, and am looking for a tool that I can throw a folder of
> Word documents at and have any macros stripped from all of them. Does
> anything like this exist? Thanks.

Not hard to write a macro that would do this. proceed as follows

Ensure that automacros are not running using this line of code

WordBasic.DisableAutoMacros 1

Then for each document, open it, save it as an RTF file, close it. Then open
the RTF file, and save it as an ordinary document again. Close it, then
delete the RTF file.

Once you have been through the batch, turn auto macros on again with this
line of code

WordBasic.DisableAutoMacros 0

The reason saving as RTF works is that the RTF file format saves all the
formatting, but doesn't include any VBA code.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Shawn Larson [MSFT] - 07 May 2008 22:40 GMT
Sidney,

I have some ideas but I need to know what version of Mac Word are you
working with.  Actually, it¹s two ideas I¹m playing with, both involve
saving the documents out to different file format versions.  Would that be a
viable option to you?

Shawn Larson
Mac Word Test
Microsoft MacBU

On 5/7/08 10:33 AM, in article
dbfdf5c1-c5a8-4118-b1b7-dd49375776cf@24g2000hsh.googlegroups.com, "SidneySM"

> I'm dealing with a few rather large and annoying macro virus
> infestations, and am looking for a tool that I can throw a folder of
> Word documents at and have any macros stripped from all of them. Does
> anything like this exist? Thanks.

Signature

This posting is provided ³AS IS² with no warranties, and confers no rights.

Clive Huggan - 07 May 2008 22:54 GMT
Hello Sidney,

You don't say whether you are operating a Mac (this is a newsgroup for users
of Word for the Mac) or a PC.

If PC: Although several people here use both PCs and Macs and may give you
an answer soon, it's likely that more people in a PC group have experienced
your specific problem. Here's where all the groups are listed:
http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

If you are on a Mac, let us know (and the exact version of Word) and
somebody [else] will help you.

Cheers,

Clive Huggan
Canberra, Australia
(My time zone is 5-11 hours different from the Americas and Europe, so my
follow-on responses to those regions can be delayed)
====================================================

On 8/5/08 3:33 AM, in article
dbfdf5c1-c5a8-4118-b1b7-dd49375776cf@24g2000hsh.googlegroups.com, "SidneySM"

> I'm dealing with a few rather large and annoying macro virus
> infestations, and am looking for a tool that I can throw a folder of
> Word documents at and have any macros stripped from all of them. Does
> anything like this exist? Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.