Running Monarch from within VBA
 

Excel Experts,

My Excel spreadsheets utilize data that I copy and paste in from a program
called Monarch. Monarch is a product from Datawatch that reads printer
report files and coverts the data to spreadsheet format.

I'm trying to figure out if I can write commands in my VBA code that can
automate the work I manually do in Monarch. The Monarch literature states:

"This doucment describes the set of Monarch properties and methods that have
been exposed for use by application developers. These properties and methods
can be called from within any application that provides support for
COM/OLE/ActiveX. This includes standard visual development tools such as
Microsoft Visual Basic, Microsoft Visual C++, Borland C++ as well as most
conventional programming languages and scripting languages such as VB Script."

My question is, should I be able to write code in my Excel VBA applications
that can go out and control Monarch, or do I have to use some other language
such as VB or VB Script?

Thanks,
Alan
--
achidsey