Get information via vba from another windows application 2

[jimwal0367]

Hi,

Is it possible to get information from another windows application like VU-ACD(aplication used for monitoring cals on a telephone system). Using an excel VBA macro.

I need to get the reports from the application onto excel, using a macro created with VBA. I know it is possible to get information from Attachmate EXTRA onto word via a vba macro

This would mean that I don't have to enter the reports manually onto excel.

Any ideas would be useful.

Thanks
jimwal0367

 

[TonyJollans]

Hi jimwal0367,

If you want to get information from (or through) another application then that really depends on what that other application makes available. Does it have a Type library which gives access to its Object Model? You can look for it under Tools > References in the Excel VBE; if there is one it should be listed (on a machine with VU-ACD installed).

If you want to extract information from a file created by another application that depends on whether you know the file format. Or whether it can write out files in a format Excel can read (CSV perhaps).


Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[CautionMP]

Yes, if the interface to the data is Extra. Here is a snipit that I wrote a year ago for MS Access, and can be easily used in Excel (although I would keep the data in Access since once the data is captured you can ad-hoc and export to Excel to your hearts content).

Can data from an Attachemate EXTRA! (CICS) session screen be captured directly into an MS Access database?

I choose to encapsulate the [tt]Attachmate EXTRA! x.x Object Library[/tt] in a custom class so I didn't have to remember how to create the connection to a mainframe session everytime I needed to write a data capture routine, but this is not necesary.

Post back if you need help picking this apart, have improvements, or need help applying it in Excel (or Access).

CMP

Instant programmer, just add coffee.