It has been a long time ive been searching solutions to my problem, so now i need your help...
Im looking for a way to create a macro from an excel file who will:
1/Open internet explorer,
2/connect to a website and login/password,
3/do an export of data, filling a form with a selection of criterias (the website allows to export a new excel file B containing data that i want to copy/paste in my initial excel file A. Those data are dynamic as i select criterias, so the excel file B is not stored somewhere in a database).
I did steps 1 and 2, but im blocked at the 3rd one. I selected the criterias I wanted for the export, and i clicked on the "OK" button which triggers the export, but then a new Internet Explorer webpage opens (blank), containing the IE window "File download - open, save, cancel?". My problem is that i cant get to the button "Open".
I found some scripts on the web using API functions findwindow, findwindowex.. but which dont work. (the following code always returns "window not found"):
(NB: Of course i declared the findwindow function before)
I tried changing the window name (my internet explorer is in french so i tried "TÚlÚchargement de fichiers" instead of "File Download" but that was unsuccessful).
I also tried to focus on the second IE window, and use sendkeys to select the "Open" button from the IE File download window, unsuccessful:
Anyway, i wonder if theres not a way to avoid the opening of this second IE windows... In the HTML code of the first IE webpage, on the "OK" button, there is this "onclick" attribute:
Maybe i could use that, but i dont know how?
Thank you very much in advance for your answers, any help will be great!!