Need to get access to FileDialog - initiated by javascript

tsuralik

New Member
Joined
Mar 18, 2010
Messages
1
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
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,136,331
Messages
5,675,156
Members
419,552
Latest member
jsanjur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top