Download file from intranet

Dear all,

I knew nothing about VBA but I managed and felt relieved to have prepared the below codes to download the loads of files in intranet weekly at work through reading online resources. I understood that SENDKEYS is an unreliable method. However, I found other methods incomprehensible. I still would like to know if there are other improvement I can make to the below code to at least download a finite number of files I need. As it is now downloading files at random, sometimes I got all the files I need, with most of the time missing 3 to 4 files at random. Thank you!

*****************************************************************************

Please Login or Register  to view this content.

Dear all,

Sorry that I have not made my query clear.

After loggin, I have to click a link (with innertext=ABC) in the menu page which would direct me to another page. There I have to click the option list to locate the table name. That's the part about "op in dropOptions list" and onchange. The interface would then list out a form for which I have to input one code from a column of an excel list for each download. I have to press "Print" button after inputting one code in the field. The webbrowser would then prompt a save button. I would then need to input another code and press "Print" again until all the files have been downloaded. The files would be downloaded to the folder "Download" directly using the sendkeys method as listed above.

Thank you for looking into this.

Microsoft Internet Controls are based on IE. IE is being discontinued and most websites don't work with it. I stopped using it about 5 years ago. To work with the web use Selenium. There is VBA COM addin called Selenium Basic. I use to use a command line tool called mget to download files. I didn't have to authenticate to access file.

Dear Mogul,
I am so grateful to your reply. I downloaded Selenium yesterday and found that I cannot have dot framework 3.5 installed since I got no admin rights. I do need loggin and type some codes to access the files. Anyway, I can see selenium is the only way now. Thank you so much for your guidance and I do hope there is leeway after 15 Jun. In fact i just figured out this automation method half year ago and was too ignorant to learn that it would fade out soon.

Dear all, I managed to download the excel files using Python with Selenium. Would there be security issue if I store the confidential data in excel and they were input to Chrome automatically using send keys?

Thanks!

Sorry that I have not made myself clear. Yes, so would there be data leak when inputting the data into chrome before it generates excel files to download? I think password would have to be set for the excel storing the data. Would there be any security risk in downloading python and selenium?