Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import and transpose tab seperated data from text file
Dave
Thanks for the link and help however i came upon a problem and I was wondering if you could help me please. The code on Chip Pearson's web site worked, with a little fiddling, if the data in the text file was in a single column. However when i ran it with the unformatted text file it went through all the enteries putting them into seperate cells on the same row. I need a program that can read a value in a text file and when it comes to a tab to stop reading (so it doesnt store the tab), it then needs to write this data into cell B1. The program must then jump to the next value in the text file and do the same but this time write it into cell B2 and so on until it reads the value u1800, after which it writes the next value in the text file into A1 and then A2 etc etc. Many thanks Phillip *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Text File with Comma Seperated Data - Need Help Pls | Excel Discussion (Misc queries) | |||
comma seperated file import | Excel Discussion (Misc queries) | |||
Import text doc to XL. Need items seperated by " " in new column | Excel Discussion (Misc queries) | |||
Import and transpose tab seperated data from text file | Excel Programming | |||
Get External Data, Import Text File, File name problem | Excel Programming |