Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import multiple txt files in worksheet and formating
Hello, I'm newbie in macro but i know something of programing. My problem is somthing like this: I have folder with multiple txt files (eg. 546.txt. 432.txt, 343.txt) Content of every file have same formating but different data 546.txt ----------------- Header Number: 546 Value1: 1345 675 Value2: 323 245 Value3: 4322 343 432.txt ----------------- Header Number: 432 Value1: 32 444 Value2: 78766 245 Value3: 12 714 Importing delimiter that i have to used is "fixed width" because i cannot get good import. For Values row there is two numbers i need that are delimited with multiple spaces (not tabs). From every file in working folder i want to import only rows Value And would like to my excel sheet look like this: Number Value1 Value2 Value2 432 32 78766 12 432 444 245 714 546 1345 323 4322 546 675 245 343 Can someone help me with this? -- -haf- ------------------------------------------------------------------------ -haf-'s Profile: http://www.excelforum.com/member.php...o&userid=37229 View this thread: http://www.excelforum.com/showthread...hreadid=569378 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
import multiple txt files in worksheet and formating
nobody knows, or nobody helps -- -haf ----------------------------------------------------------------------- -haf-'s Profile: http://www.excelforum.com/member.php...fo&userid=3722 View this thread: http://www.excelforum.com/showthread.php?threadid=56937 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import multiple text files into a single worksheet | Excel Discussion (Misc queries) | |||
Import of multiple .CSV files into Excel | Excel Programming | |||
Multiple txt files import | Excel Programming | |||
formating multiple excel .csv files ? | Excel Programming | |||
Import multiple files macro can't find files | Excel Programming |