Import CSV File from web in sheet for each cell value and name sheettab accordingly

Background: Excel 2003
Sample file attached herewith.
Cell D1, has working date, immediate preceding today.
Based on G1 value, past 'n'days, date in Cell B1 (D1-G1) is worked out again to have working day(not weekends).
So, we will have From Date (B1) TO Date (D1) Range for data selection.

Cell A4, A5,A6 would have distinguisher for which data has to be pulled from a website within above date range limit.

Cell B4, B5,B6 and so on in Column B, would generate dynamic web URL based on Cell A4,A5,A6 in combination with DATE range given above. (Sample URL given).

If this is done on screen, the screen would appear as given in the attached excel, with option to download these data in CSV format.

Query/Help sought:
Now, I want a VBA Macro that could import the CSV file in separate sheet, rename it to the corresponding Cell value, say A4, if already does not exist. If Sheet with name Cell A4 already exisit, macro should first clear all data, and then import the data specified above.

Thanks

Hello analystbank,

The macro below will create a new sheet if needed or overwrite data on an existing sheet. A button has been added to "Sheet1" to run the macro.

Please Login or Register  to view this content.

Thanks for response, but seems something wrong at my end? Nothing comes up, and data downloaded by you in one of the sheet also gets cleared.

do I need to activate, any of the Library in References? I'm using Excel2003 version.

What is the trick, if i want to add further Rows in Sheet1, Say A7, A8, and so on, and have corresponding Sheets separately to have data, in respective sheets?

Hello analystbank,

You don't need to add any libraries to your project. The necessary objects are created using late binding.

I don't believe running the macro on Excel 2003 should be a problem. What version of Internet Explorer are using?

Here is the error screen shot

http://postimg.org/image/xzytk9n17/

Coincidentally, yesterday only my system was replaced. I now have Internet Explorer 11, Win8 Operating system with Office 2013. But the given excel was in Office 2003 version.

You appear to have successfully downloaded the data. Kindly guide me, since it is not working at my end. Sometime, above error comes, or else macro just gets executed, but no data is found in the respective sheets!!! Please help.

Hello analystbank,

This is a major game changer. Windows 8 does not play well VBA. The preferred language with Windows 8 is VB.net. You could also be experiencing problems due to OS bit size. This macro code is written for 32 bit OS. Your system installation may be 64 bit only with no support for 32 bit. You need to find out which you have.

Hello Hello analystbank,

The code works on either of my machines. One is Windows XP running Office 2003 and the other is running Windows 7 64 bit with 32 bit support and Office 2010.

What happens when you trying running the code at home?
Have you enabled Excel to run VBA macros in the Trust Center settings?
Does the workbook load?
Do you get an error messages?

Sir,

1) On Win8 Office 2013 - Macro just gets executed, but I dont find any data in respective sheets. No Error at the time of macro processing, and No Result (Output)

2) On WinXP, Office 2007 - I get Error message (Compile Error - Cant Find Object or Library ) at line

Please Login or Register  to view this content.

HTML Code: 

I dont understand, what to do