Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find from Excel VBA a text file last row
Hi! I am trying to export to a text file an excel range. this text file must be updated every X time so when importing new cell to the Text file, I dont want to delete the previous data. I mean if today text file's: 1 row= Hello 2Row= hi and I have to export Bye my text file's 3row must Bye text file 1 row= Hello 2Row= hi 3row=Bye How do i know a Specific text file's last row?? Sub How() Dim Filename As String Filename = "C:\windows\desktop\XXX.txt" Open Filename For Output As #1 Write #1, Data;'data comes from one other source 'Close #1 End Su -- 0000_AAAA_000 ----------------------------------------------------------------------- 0000_AAAA_0000's Profile: http://www.excelforum.com/member.php...fo&userid=1248 View this thread: http://www.excelforum.com/showthread.php?threadid=26889 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find from Excel VBA a text file last row
Change this line : Open Filename For Output As #1
To : Open Filename For Append As #1 Then it will just add the data to the end of the file. Ryan "0000_AAAA_0000" wrote: Hi! I am trying to export to a text file an excel range. this text file must be updated every X time so when importing new cells to the Text file, I dont want to delete the previous data. I mean if today text file's: 1 row= Hello 2Row= hi and I have to export Bye my text file's 3row must Bye text file 1 row= Hello 2Row= hi 3row=Bye How do i know a Specific text file's last row?? Sub How() Dim Filename As String Filename = "C:\windows\desktop\XXX.txt" Open Filename For Output As #1 Write #1, Data;'data comes from one other source 'Close #1 End Sub -- 0000_AAAA_0000 ------------------------------------------------------------------------ 0000_AAAA_0000's Profile: http://www.excelforum.com/member.php...o&userid=12480 View this thread: http://www.excelforum.com/showthread...hreadid=268898 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find a deleted excel file? Or an autosave file? | Excel Discussion (Misc queries) | |||
clicking .XLS file opens Excel 2003 but doesn't find the file | Excel Discussion (Misc queries) | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Excel VBA - open text file, replace text, save file? | Excel Programming | |||
Doing a find and replace in a text file | Excel Programming |