Problem with dynamically parsing the VBA File

Question

I have an MS Office 2003 excel file with macro. I have to parse the VBA code in macro using c#. While parsing i have to identify whether the keyword is a method name or property.

And also is there a component from Microsoft to access all the VBA functions dynamically using reflection in c#?

Is there a way to do this? If so please suggest.

Dirk Vollmar · Accepted Answer · 2009-03-09 12:08:00Z

1

Because the syntax of reading a property and calling a sub/function without parameters might be identical you will have to resolve all symbols and check their definition to see whether a symbol is a property or a sub/function.

answered Mar 9, 2009 at 12:08

Dirk Vollmar

177k53 gold badges261 silver badges318 bronze badges

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

Comments

CodeMonkey1313 · Accepted Answer · 2009-03-09 12:08:53Z

0

The easiest would be to track whether the object name is preceded by "Function" or "Sub" as that would indicate a method name as opposed to a property

answered Mar 9, 2009 at 12:08

CodeMonkey1313

16.1k19 gold badges79 silver badges110 bronze badges

1 Comment

Dirk Vollmar Over a year ago

This however would only work for property/method definitions. I think the OP wants to know whether a reference is a method or a property.

Collectives™ on Stack Overflow

Problem with dynamically parsing the VBA File

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related