Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Yes, our VB6/COM processor can be used to help rewrite VBA.

I assume by VBA you mean code in MS office (Word, Exel, Access) product macros. VBA macro's look a lot like VB6 and they also use many VB6 conventions; however VBA macros run within a host office application and therefore they have access to the host office application objects and its APIs more directly that similar VB6 code would.

When you rewrite VBA macros as VB.NET (or VB6 for that matter), the code will no longer be within the host application. You need to reference and instantiate an office application instance and also possibly load a document. Then you will automate that office application instance and manipulate the document.

Furthermore, our VB6 process is designed to work with VBPs and the code/COM files they reference. In order to use this machinery, the VBA code needs to be extracted from the VBA macros and wrapped in a VBP. Its not a big deal and we have a VBA extraction tool to automate that process. The extraction tool also does some of the work relating to the changing the application to an application instance as described above.

The bottom line is the tool can be a great help with this, but it does not currently do is completely automatically right out of the box yet.

If you can tell me more about your requirements that would be a help and if you have a VBA sample, I will be happy to demonstrate what we can do and go from there.

  • No labels