IE Automation - How to update input element and update

If the button is a click button then your code will need to button.click or if it is a submit button then your code will need to button.submit

Activating the download button will open the IE notification frame...manipulating the IE notification frame with VBA is beyond my ability but certainly do-able.

Thanks. What if it is just a hyperlink; i.e., highlighted text which when clicked, opens the IE notification frame?

Getting the notification frame to open is the easy bit, if it is just a link then you can just follow the hyperlink. Find the element that holds the hyperlink and navigate the URL.


Here is an example what you need to do once the frame notification bar opens.
https://stackoverflow.com/questions/...ar-save-button

Please Login or Register  to view this content.

Thanks, anrichards22, but your suggestion doesn't work either. Before manipulating the downloaded book, I activate the initiating book. After manipulating the downloaded data using a 'With', with the initiating book window open, I still cannot execute a floow up command.

Please Login or Register  to view this content.

Try using the actual name of your workbook

Workbooks("XYZ.xlsx").activate