Linking CSV file
Hi
I run W2K with Excel 2K.
I have a workbook that links to a file on a server. The file on the server
is a file that is downloaded from a mainframe in a CSV format. Also, although
this file is a csv format it has been setup to download with a .XLS extension.
For my workbook link to this file to work correctly, I have to open up the
csv file and save it as an true Excel file. If I do not do this then the file
on my computer does not automatically update the links.
Is there anyway I can have my links to automatically update correctly
without having to save the csv file as an Excel file?
Any help is much appreciated.
John
|