My first post - any help would be greatly appreciated!
I'm running VBA code in excel to login to a website (requiring certificate authentication), navigate to a form, populate the form, and submit the form data.
The website pops open a new window, which i get a handle to, and eventually displays the results in a HTML table.
At the top of the results page, there is a jsp tag/link with a button that allows me to download the HTML table data as an Excel file. I can invoke the button click to initiate the action.
The problem I have is: how do i get a handle to the FileDialog that pops up so I can specify the directory/filename and click the OK button??
An additional nugget: what might be different if the "Do you want to save this file?" confirmation prompt appears before the FileDialog?
Any help would be greatly appreciated.
Thanks for your time
I'm running VBA code in excel to login to a website (requiring certificate authentication), navigate to a form, populate the form, and submit the form data.
The website pops open a new window, which i get a handle to, and eventually displays the results in a HTML table.
At the top of the results page, there is a jsp tag/link with a button that allows me to download the HTML table data as an Excel file. I can invoke the button click to initiate the action.
The problem I have is: how do i get a handle to the FileDialog that pops up so I can specify the directory/filename and click the OK button??
An additional nugget: what might be different if the "Do you want to save this file?" confirmation prompt appears before the FileDialog?
Any help would be greatly appreciated.
Thanks for your time