get window nfo

[alcoool]

hy to all!
I have the folowing problem:
1. I'm using the vba from access 2003 with sendkeys function to operate another program.
2. I get to a window in that program and i want to retrive some data from it
3. the data is in a tipe of list that i can't do ctrl-c on it to get the data
4. the data is also stored in the footer of the window

Is there a way to retrive that data and store it in a variabile in vba?



Thank you!!

P.S. print screen attached

[jbarrum]

you are not going to get to it that way. You will need to install and ODBC driver that will allow you to connect to the DB that is storing the information for that program and then link to the tables needed to create a query if neccessary to bring what data together you need into one view.

[alcoool]

you are not going to get to it that way. You will need to install and ODBC driver that will allow you to connect to the DB that is storing the information for that program and then link to the tables needed to create a query if neccessary to bring what data together you need into one view.

I'm not alowed access to that database, so i can not do what you say

[jbarrum]

I do not think you will have much luck then. Someone else might have another idea but that is the only way that I know of to get to the information you need.