Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to text file
I am looking to link to data saved within a text file using excel. How can I
do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to text file
Chris,
What do you actually want to do? Reading from or writing to a text file is something Excel can do, for eaxmple the code below reads in 1 line at a time from a text file and copies it to a worksheet. Sub importtext() x = 1 Open "c:\trial.txt" For Input As #1 Do While Not EOF(1) Input #1, Line Worksheets("sheet1").Cells(x, 1).Value = Line x = x + 1 Loop Close #1 End Sub Mike "Chris" wrote: I am looking to link to data saved within a text file using excel. How can I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link to text file
Hi Mike,
The text file is a report which contains telephone data. I need to take the total number of calls received and answered from the file, and the date which is in the file. The rest of the text in the file I don't need. Is there any way of doing this with a formula as unfortunately I don't understand macro coding. Thanks for your help. Chris "Mike H" wrote: Chris, What do you actually want to do? Reading from or writing to a text file is something Excel can do, for eaxmple the code below reads in 1 line at a time from a text file and copies it to a worksheet. Sub importtext() x = 1 Open "c:\trial.txt" For Input As #1 Do While Not EOF(1) Input #1, Line Worksheets("sheet1").Cells(x, 1).Value = Line x = x + 1 Loop Close #1 End Sub Mike "Chris" wrote: I am looking to link to data saved within a text file using excel. How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Link footer of one file to cells in another file | Excel Discussion (Misc queries) | |||
Using text in cells to build a link to within another file | Excel Discussion (Misc queries) | |||
External link only works for numbers -- for text values, #N/A is displayed unless linked file is open | Links and Linking in Excel |