Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to link ot a data in a csv file?
I have a csv file that automatically generated (update) every 15 minutes
from a computer server (which I cannot control). The csv file is only one row and 7 data separated by commas. The filename and format of this csv file are always the same. In another workbook, I would like to link a cell to one of the data of the above csv file. At the moment, I need to open the csv file manually and then copy the required data to my spreadsheet. Is it possible to extract the data from the csv file without opening the csv file? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to link ot a data in a csv file?
You could write a macro - I don't know if that's something you've done before.
Easier though is to link to the cell in the csv for example have one spreadsheet with all the analysis functions in or whatever you want... then set the cells as =test.csv!$E$1 (you can put the other 6 items in other cells as increments e.g. =test.csv!$E$2 etc) then your master spreadsheet will update with the latest value from your server everytime you open it or calculate a cell (usually automatic or press F9) "Lamb Chop" wrote: I have a csv file that automatically generated (update) every 15 minutes from a computer server (which I cannot control). The csv file is only one row and 7 data separated by commas. The filename and format of this csv file are always the same. In another workbook, I would like to link a cell to one of the data of the above csv file. At the moment, I need to open the csv file manually and then copy the required data to my spreadsheet. Is it possible to extract the data from the csv file without opening the csv file? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to link ot a data in a csv file?
You could open the file as a text file.
Then go to the line that you want. Parse the data to separate each field that you want. and then close the file. But it may be easier just to open the .csv file, copy and paste the info you need from that new workbook. Then close the .csv file. If you have to do it lots of times, you could record a macro that does the work. Drop a button from the Forms toolbar onto a nice spot on the worksheet. Then assign the recorded macro to that button. And hit the button whenever you needed to update that data. Lamb Chop wrote: I have a csv file that automatically generated (update) every 15 minutes from a computer server (which I cannot control). The csv file is only one row and 7 data separated by commas. The filename and format of this csv file are always the same. In another workbook, I would like to link a cell to one of the data of the above csv file. At the moment, I need to open the csv file manually and then copy the required data to my spreadsheet. Is it possible to extract the data from the csv file without opening the csv file? Thanks. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to link ot a data in a csv file?
Thanks you guys for the prompt reply. I have found a better way to update
the data. Not too sure if you guys find this useful for you in the future. In the Data menu, Get External Data, Import Text file, I can put the location of the csv file and decide which column not to import. Before it finish, click on the Propterties botton, I can ask excel to update its data every 15 minutes itself. By this way, it solved my problem. "Dave Peterson" wrote in message ... You could open the file as a text file. Then go to the line that you want. Parse the data to separate each field that you want. and then close the file. But it may be easier just to open the .csv file, copy and paste the info you need from that new workbook. Then close the .csv file. If you have to do it lots of times, you could record a macro that does the work. Drop a button from the Forms toolbar onto a nice spot on the worksheet. Then assign the recorded macro to that button. And hit the button whenever you needed to update that data. Lamb Chop wrote: I have a csv file that automatically generated (update) every 15 minutes from a computer server (which I cannot control). The csv file is only one row and 7 data separated by commas. The filename and format of this csv file are always the same. In another workbook, I would like to link a cell to one of the data of the above csv file. At the moment, I need to open the csv file manually and then copy the required data to my spreadsheet. Is it possible to extract the data from the csv file without opening the csv file? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel unable to importa data from "mdb" file link | Excel Discussion (Misc queries) | |||
Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
Excel file link with word file | Excel Worksheet Functions | |||
Q: Can a formula reference a cell to get the file name to link to for data? | Excel Discussion (Misc queries) | |||
How do I link data from another workbook using a different file na | Excel Discussion (Misc queries) |