Check whether an Excel workbook has macros using C#

Question

I need to go through hundreds of Excel files to find those that have macros, using a C# client.

I have tried using the code in the accepted answer here:

Using Interop.Excel to check if Excel file contains VBA Macros

However, this code opens the file first. Many of the files are opening pop up Windows and VBA error messages even after adding _appExcel.DisplayAlerts = false

Its also very slow. Is there a better way to go about this, ideally without opening the Excel file first?

I have looked for documentation on MSDN for Excel interop here: HasVBProject but there are no examples I can work with.

Too bad there are XLSB. XLSM are simply .zip files, you could work directly on that... — Pierre
– Pierre, Commented Jan 13, 2017 at 17:44

h2so4 · Accepted Answer · 2017-01-13 15:35:23Z

0

try this

f = Dir("*.xls*")
While f <> ""
On Error Resume Next
    Set wb = Workbooks.Open(f)
    If wb.HasVBProject Then
       Debug.Print wb.Name & " has macro"
    Else
        Debug.Print wb.Name & "does not have macro"
    End If
    wb.Close
    f = Dir
Wend

answered Jan 13, 2017 at 15:35

h2so4

1,5771 gold badge10 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nick Over a year ago

Hi, thanks but this looks like VBA.im using a C# client to enumerate the files.

Jonathan Applebaum · Accepted Answer · 2017-01-13 15:37:16Z

0

if workbook events is the problem than you can disable all macros using Interop.Excel namespace via AutomationSecurity property :

MyExcel.Application.AutomationSecurity = Microsoft.Office.Core.MsoAutomationSecurity.msoAutomationSecurityForceDisable;

answered Jan 13, 2017 at 15:37

Jonathan Applebaum

6,0164 gold badges40 silver badges58 bronze badges

1 Comment

Nick Over a year ago

Thanks I'll give it a try.

Collectives™ on Stack Overflow

Check whether an Excel workbook has macros using C#

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related