M
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
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