Hello Everyone, I've seen may VB scripts that look at text files and extract information from it and then import everything in excel. I don't have a specific Text file I am working on but is there a generic sample of script you can share with me that will show me how to basically.
1. Read a file saved on my C:\ called Sample.txt 2. Extract everything from say character 2 to character 50 3. Import everything in an Excel Spreadsheet called Sample.xls and save it on my C:\ drive
I've read many books on VB but haven’t found anything that demonstrates how to extract data from text files effectively. Also if you have any good sites or books that will demonstrate with various examples how to do this I would appreciate it.