HOw to read text file that will return the value to excel
-
Hi... can anybody show me how to read text file that will return the desired value to ms excel format. Just to give a bit background that I need to do. I have a source file which is text format. I need to read that text document and return the specific information that I want to my excel format. My excel has already a designed template where I will put the information from the text file in a certain field/row/cell in my excel. Appreciate you kind help and your quick response on this. Many thanks in advance.:-O
-
Hi... can anybody show me how to read text file that will return the desired value to ms excel format. Just to give a bit background that I need to do. I have a source file which is text format. I need to read that text document and return the specific information that I want to my excel format. My excel has already a designed template where I will put the information from the text file in a certain field/row/cell in my excel. Appreciate you kind help and your quick response on this. Many thanks in advance.:-O
You could cheat... Open Excel and your spreadsheet, start recording a macro, simulate the text you want to add manually in the spreadsheet then look at the code the macro created. This should give you a good starting point for automating Excel, If you get stuck with specifics post here and I'll help out. Hope this helps Tom
-
You could cheat... Open Excel and your spreadsheet, start recording a macro, simulate the text you want to add manually in the spreadsheet then look at the code the macro created. This should give you a good starting point for automating Excel, If you get stuck with specifics post here and I'll help out. Hope this helps Tom
Hi tom thanks I really appreciate your help. I got your instructions but I still have many questions. Once I recorded the manual filling of the records I want to transfer from text file to excel, whats next? The source file is changing monthly. I mean the positioning of the specific record in the text file is changing. Will this way still work? Thanks.
-
Hi tom thanks I really appreciate your help. I got your instructions but I still have many questions. Once I recorded the manual filling of the records I want to transfer from text file to excel, whats next? The source file is changing monthly. I mean the positioning of the specific record in the text file is changing. Will this way still work? Thanks.