Aranell
05-12-2014, 05:30 AM
Hi is there a way to switch between excel and an other running windows already running program?
I know how to use AppActivate and CreateObject etc... but as far as i know it's working with only a few application like office etc..
I'm working with a reservation system calles Altea Amadeus, which is opens through internet explorer (it's actually not open IN internet explorer, only by clicking a link it will open for me the application)
I have check every week in amadeus the load of our aircraft for the next 4 Months. I'm doing so by typing a command (ll/Flightnumber/date) we have a daily flight and as you would presume entering the same command and coping the load to an excel sheet and this 120 times each week is too much work.
I thought i could automate this process by coping the command from excel switching to amadeus than paste the command using
SendKeys "^v" then wait 5 second sellect all and copy using again
SendKeys
I tried with only using
SendKeys ("%+{TAB}") but it didn't work
is this possible to do with excel vba or do i need to try java or c++?
I know how to use AppActivate and CreateObject etc... but as far as i know it's working with only a few application like office etc..
I'm working with a reservation system calles Altea Amadeus, which is opens through internet explorer (it's actually not open IN internet explorer, only by clicking a link it will open for me the application)
I have check every week in amadeus the load of our aircraft for the next 4 Months. I'm doing so by typing a command (ll/Flightnumber/date) we have a daily flight and as you would presume entering the same command and coping the load to an excel sheet and this 120 times each week is too much work.
I thought i could automate this process by coping the command from excel switching to amadeus than paste the command using
SendKeys "^v" then wait 5 second sellect all and copy using again
SendKeys
I tried with only using
SendKeys ("%+{TAB}") but it didn't work
is this possible to do with excel vba or do i need to try java or c++?