VBA code to run an apllication and get the data back to excel

[MrXYZ]

Hi,
I am trying to using vba macro for open another application (ibm wrq reflection) where i need it to automatically login by entering username and password (which i already put on cell A1 username and B1 password). After successfull login i want it to entering jump string (copy paste from C1) after it open.. i need the screen data is exported to active sheet. And it need looping until the last data preserved on the A2,A3, so on.

Can somebody help?

Thanks a lot before

 

[Legacy 456155]

It's been years since I have worked with reflection, but I do recall that it hosts VBA and also provides a COM interface. You may be better off coding from within Reflection and fetching the data from Excel. From Excel, you can either create a reflection object and use it's various properties and methods or settle for something like sendkeys. I don't have access to Reflection and thus, I cannot provide you with an example. I do remember the model was very simple and intuitive.

 

[MrXYZ]

It's been years since I have worked with reflection, but I do recall that it hosts VBA and also provides a COM interface. You may be better off coding from within Reflection and fetching the data from Excel. From Excel, you can either create a reflection object and use it's various properties and methods or settle for something like sendkeys. I don't have access to Reflection and thus, I cannot provide you with an example. I do remember the model was very simple and intuitive.

Ok dataluver, thanks for your input.