Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read data from a text file (*.txt)
Hello:
My goal is to be able read data (seperated by semicolon) from a text file (*.txt). The QueryTable object is NOT an option because I then have to limit the number of data to 256, which is the max number of the worksheet's columns. And I am talking about 400 data in a single line. If there is a way to read the data directly from a text file (without writing it on a worksheet) and assign it to variables/arrays in VBA, I believe that I can accomplish my goal. Does anybody know a piece of code that can do this? Thanks, Adrian T |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data from exported file read as text, when edited becomes a # (pic | Excel Discussion (Misc queries) | |||
to read text tablimited file | Excel Discussion (Misc queries) | |||
How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Read text file | Excel Programming |