I need to extract a specific line from a text file and what that line to a new file.

[Dhiru16]

thread329-1148463

Hey can I know how to write the text to a new file. I'm a bit new to it,any help is greatly appreciated!

Thanks
Dhiru

 

[mikrom]

try something like this

'file name
output_file = "output.txt"

'create File System object
set Fso = CreateObject("Scripting.FileSystemObject")

const ForReading = 1, ForWriting = 2, ForAppending = 8 
'open the output file for writing
set oOutFile = fso.OpenTextFile(output_file, ForWriting, True)

out_line = "Hello"
'write to the output file
outFile.WriteLine(out_line)

'close the output file
outFile.close

 

[Dhiru16]

Thanks Mikron,

What i'm looking for is i got a excel sheet from that i have to extract the specific field something like this Date:09-10-2020 and have this moved into a different file.

 

[mikrom]

To work with excel files I used to use the object Excel.Application:

objExcel = CreateObject("Excel.Application")

But I'm not sure if it still works with newer windows and excel versions