Macro to Download csv file from a dynamic date based url to a specified file location

**srimani202002** · 02-23-2014, 03:39 AM

Hi,

I have a requirement to download a lot of historical data files from the archieve of an website. The url goes something like this:
http://nseindia.com/content/nsccl/fa...i_21022014.csv

This downloads file for 21022014 ie. 21-Feb-2014. I need to be able to have a facility to have a selection criteria on my user form (in excel) where I specify a date range and the macro automatically downloads all the valid excel files available within that date range (files for Saturday, Sunday and some holiday dates will not be available in the website archive database) one after the other (like at single clcik of button) into a specific location (predefined viz.. c:/Users/EOD files/) on my laptop. Best would be if I am able to select the save location run time by using a 'Browse' like feature where I go and choose my local laptop folder...same type when we try uploading a file from our laptop to the web..

Request an urgent help and response please.

Regards
Shankhajit

**HaHoBe** · 02-23-2014, 07:17 AM

Hi, srimani202002,

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.mrexcel.com/forum/excel-q...ons-macro.html

http://www.ozgrid.com/forum/showthread.php?t=186402

Ciao,
Holger

Macro to Download csv file from a dynamic date based url to a specified file location

LinkBack

Thread Tools

Rate This Thread

Display

Macro to Download csv file from a dynamic date based url to a specified file location

Re: Macro to Download csv file from a dynamic date based url to a specified file location

Thread Information

Users Browsing this Thread

Similar Threads

Macro to search file location for presence of a specific file

[SOLVED] Macro to Save File to Location Folder Based on Date in Cell

Save as macro that specifies file type, file location and takes file name from three cells

[SOLVED] [Help]macro to open file browser, to select a location, and save the location to a cell

Macro that opens file from location, strips links and saves to new location

Bookmarks

Bookmarks

Posting Permissions