To find if an excel file has got VBA code in it irrespective of the version of excel(it can be any version of excel)

[Suj_78]

Hi Guys, I am trying to find a property or method in Microsoft.Office.Iterop.Excel which will help me make a decision whether an excel file (can be any version of excel) has got any VBA code or macro. Can anyone help me with this. So far I have found the following property that deals only with excel 4.0 worksheets: Excel4IntlMacroSheets 'Returns a Sheets collection that represents all the Microsoft Excel 4.0 international macro sheets in the specified workbook. ' Excel4MacroSheets 'Returns a Sheets collection that represents all the Microsoft Excel 4.0 macro sheets in the specified workbook. ' Any help will be appreciated. Thanks

happy coding!

[Alaric_]

You might want to rephrase your question in such a way that it makes it clear that you are attempting to do this in a C# implementation(Assuming that you ARE in fact trying to do this in C#) If you are not doing this in C#, you probably want to repost this in the appropriate forum. People sometimes get kind of "touchy" in here.

"I need build Skynet. Plz send code"