Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Monarch through VBA
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Monarch through VBA
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fix problem pasting columns to Excel from Monarch? | Excel Discussion (Misc queries) | |||
Controlling Userforms | New Users to Excel | |||
Running Monarch from within VBA | Excel Programming | |||
Controlling IE from Excel | Excel Programming | |||
Controlling VBA | Excel Programming |