Controlling Monarch through 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

Sounds like you can do it through VBA - You will need to add a reference
through the Tools... References menu. If you see Monarch in the list, add
it; if not check the Monarch documentation to see if it tells you the name
and location of the library file so you can add it to the list.
--
- K Dales


"achidsey" wrote:

> 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

Thanks, that gives me a place to start.

Alan

--
achidsey


"K Dales" wrote:

> Sounds like you can do it through VBA - You will need to add a reference
> through the Tools... References menu. If you see Monarch in the list, add
> it; if not check the Monarch documentation to see if it tells you the name
> and location of the library file so you can add it to the list.
> --
> - K Dales
>
>
> "achidsey" wrote:
>
> > 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