• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Download excel files from internet

S

saurabhlotankar

New Member
Hello,


I need to download certain files from my companys website everyday. Is there any way through which i can create an formula which will automatically download files from web a specified webpage of specific date mentioned by me.
 
Hi, saurabhlotankar!

First of all, formulas doesn't perform such kind of actions, they just calculate values. Depending on where and how is the source used for calculations, they might access to those local or networked files

Second, you need a procedure (macro or piece of VBA code) to perform download operations, but they'll all depend on the method you'd have to use to get access to your file. If they're at your company's website you should start asking that to your IT support team, help desk, or however you called that people.

Regards!
 
Ya, Exactly thats what i wanted. A macro that will download all the files of the date i will mention on one click.

No issues about the company website. I will take permission from IT department. But i should have the macro ready before that. So if you could provide the code along with the procedure then that will be great.

Thanks
 
Hi, saurabhlotankar!

As Jack said, let us go by parts. First define where and how are the files you want to downloadm, then ask and get access to them, then manually download them until you (or anybody) end the macro developing.

Regards!
 
You must log in or register to reply here.
Back
Top