Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking CSV file
Hi John,
Not really, but you could automate the opening of the csv file whenever you open your Excel workbook. Also, it's not a good idea to mis-name the csv file's extension. This makes no difference to how Excel processes the file, but it's misleading, since any app capable of reading a text file (eg Notepad, Word) can also read csv files, but not necessarily Excel (xls) files. Cheers -- macropod [MVP - Microsoft Word] "John Calder" wrote in message ... | 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 |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking CSV file
Thanks for your response. I am not exactly sure how to open the csv file
automatically from my workbook but I will ask the question in another work group. As for naming the csv file with a xls extension I am afraid I dont have any control over that so I will have to work with what I have got. Thanks again John "macropod" wrote: Hi John, Not really, but you could automate the opening of the csv file whenever you open your Excel workbook. Also, it's not a good idea to mis-name the csv file's extension. This makes no difference to how Excel processes the file, but it's misleading, since any app capable of reading a text file (eg Notepad, Word) can also read csv files, but not necessarily Excel (xls) files. Cheers -- macropod [MVP - Microsoft Word] "John Calder" wrote in message ... | 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 |
#4
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking CSV file
Hi John,
If you use Data - Import External Data and point to the csv file as the external data source, then you will have a data range that can be refreshed at any time. Ed Ferrero 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 |
#5
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking CSV file
Thanks Ed !
But I run Excel 2000 and when I select "Data" I dont get "Import External Data" as an option. My options are; Data Get External Data Import Text File Thanks "Ed Ferrero" wrote: Hi John, If you use Data - Import External Data and point to the csv file as the external data source, then you will have a data range that can be refreshed at any time. Ed Ferrero 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 |
#6
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking CSV file
Hi John,
In Excel 2000, use Data - Get External Data. Other steps are the same. Ed Ferrero www.edferrero.com Thanks Ed ! But I run Excel 2000 and when I select "Data" I dont get "Import External Data" as an option. My options are; Data Get External Data Import Text File Thanks "Ed Ferrero" wrote: Hi John, If you use Data - Import External Data and point to the csv file as the external data source, then you will have a data range that can be refreshed at any time. Ed Ferrero 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 |
#7
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking CSV file
John, did you ever solve this problem? I download
my bank account files in CSV but IE won't give me the option to save or run, they just automatically open up in IE html format. "John Calder" wrote in message ... Thanks Ed ! But I run Excel 2000 and when I select "Data" I dont get "Import External Data" as an option. My options are; Data Get External Data Import Text File Thanks "Ed Ferrero" wrote: Hi John, If you use Data - Import External Data and point to the csv file as the external data source, then you will have a data range that can be refreshed at any time. Ed Ferrero 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 |
#8
Posted to microsoft.public.excel.links
|
|||
|
|||
Linking CSV file
HI,
I NEED TO KNOW THAT I AM USING OFFICE2003 FOR THAT HOW CAN I DOWNLOAD CSV FILE AUTOMATICALLY IN EXCEL & CAN I UPDATE AUTOMATICALLY HELP REQUIRED THANKS AVINASH "Bubey" wrote in message ... John, did you ever solve this problem? I download my bank account files in CSV but IE won't give me the option to save or run, they just automatically open up in IE html format. "John Calder" wrote in message ... Thanks Ed ! But I run Excel 2000 and when I select "Data" I dont get "Import External Data" as an option. My options are; Data Get External Data Import Text File Thanks "Ed Ferrero" wrote: Hi John, If you use Data - Import External Data and point to the csv file as the external data source, then you will have a data range that can be refreshed at any time. Ed Ferrero 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show file path in formual bar when linking workbooks? | Excel Discussion (Misc queries) | |||
disc full, saved to temp. file | Excel Discussion (Misc queries) | |||
Linking a worksheet from a different excel file | Excel Discussion (Misc queries) | |||
file will not open | Excel Discussion (Misc queries) | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) |