excel 2007: importing data from CSV online

[zimu]

hey guys,

there's a CSV file online which updates every minute. I want to be able to make an excel sheet which pulls data from the csv sheet and manipulates it the way I want.

What i've done so far is create an excel document, under data said get external data, from text, and pasted in the url for the CSV. This is all fine and great - it pulls the data into the sheet.

How do I get it to update though? I tried to record a macro that simply clicked on the refresh button and pasting in the url of the csv file, but i don't think that gets translated into the macro code itself.

Any ideas?

 

[Cogman]

The easiest way to deal with something like this is to query the database instead of reading in the CSV. Heck, it might even be easier to import the data into SQL Server and then do the manipulation there.

However, If you really want to do it, you are probably going to have to write some macros, I don't know that a simple recording of macros will cut it. (but I could easily be wrong on this one)

 

[Evadman]

Refresh on demand:
1. Select the worksheet with your imported file.
2. Click Refresh Data Button on the External Data toolbar. (It looks like a red exclamation point).

Refresh at intervals:
1. Click a cell in the external data range and then click Data Range Properties Button image on the External Data toolbar.
2. Select the Refresh every box, and then enter the number of minutes between refreshes

Refresh on open:
1. Click a cell in the external data range you want to refresh.
2. Select the Refresh data on file open check box.
3. If you want to save the workbook with the query definition but without the external data, select the Remove external data from worksheet before saving check box.