Checking for macros in documents without opening them

A

AKA Bones

Apologies if this is in the wrong group:

Does anyone know of a programatic way to determine whether a document /
spreadsheet / presentation contains one or more macros BEFORE the file is
opened?

We have a problem whereby macros in files are preventing our automated
process from completing because a macro has run and prompted the user for
input, but because we're opening the document using VB6 / .net using the
object model nothing is displayed so there's no way to close the prompt.

If we set the macro security in Word to high, all macros are prevented from
running but Word prompts the user when a document is opened which contains
macros: "The macros in this project are disabled. Please refer to the online
help or documentation of the host application to determine how to enable
macros.". This prompt also prevents our system for processing the document
due to the dialog box.

If anyone can help I would really appreciate it.

Cheers,
Andy
 
S

Stefan Blom

You had better ask in a programming newsgroup such as
microsoft.public.word.vba.general for assistance with this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding macros in Office documents without opening them 0
Finding macros if Office documents without opening them 0
Building Blocks and Macros 5
Determining whether Office documents contain macros 1
Global Template Network and saving auto texts & macros 2
Template location changes from user to user 0
Want to have macro execute automatically when doc created 3
Email notifications without opening application 1

Top