Linking data from .CSV to Excel - HELP!

[MrMerton]

Hello!

I'm completely stuck. I have an excel spreadsheet that uses data fro
a .CSV file. This data (all numbers) is linked to a sheet in th
workbook. The problem is this:

in order for the data to be updated, it is necessary to open up th
.csv file whilst the workbook is open. This is a terrible hassle.
have tried making a macro that opens the .csv file and then closes i
again, but that doesn't appear to update the linked data fields. Th
Edit/Links/...update links function won't work, since Excel say
"External Copy: file format is not valid".

Does anyone have any idea how I can have the spreadsheet update th
fields without having to open up the .csv file myself? Incidentally
the .csv file is continuously changing (as it is outputted by anothe
software program), so I cannot use another file format.

Any help would be VERY gratefully received.

Many thanks!

Wil

 

[Earl Kiosterud]

Will,

It sounds as though you've opened the csv file in Excel, then linked to your
other workbook. With Excel 2002 you can use Data - Import External Data to
set up a permanent link to a csv file. It will read the csv data into a
worksheet at your specified location. You use the Refresh command (in
right-click menu) to re-read it, updating the worksheet. I don't think this
is provided in Excel 2000.