Auto save IE file download dialog box in a user defined path

Hi All,

I am trying to automate the file download dialog box. User will enter the path in a cell of excel sheet on where to save the file. Then the file download dialog box of IE should save the file in that path. I tried the below code. But its not working. It stuck up at save as step. can someone please complete it.

Please Login or Register  to view this content.

Thanks in advance..!!

Bringing this thread up.. Can someone please help

There is no real way to do what you want properly because you're not really doing it in the right way.

You should be downloading the file directly from Excel, not using IE - this bypasses all the IE UI including the download dialogue. The complexity in doing this depends entirely on the web page in question, but it is the correct way of solving the issue

The issue comes at this line under Save_As_Filename function

Please Login or Register  to view this content.

hwnd returns 0. I guess ComboBoxEx32 is not found.

Do anyone have idea on this