Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi guys,
If anyone could give me some pointers on how to go about this I'd appreciate it very much. situation: I have to import various textfiles using VBA. I select the filename and path which comes from a listview and a textbox on a userform. So far so good. The textfile however is setup as follows: xxx xxxxx xxxx xxxxx xxxxx The data has fixed length for example the first field is 10chars, the second 20chars, the third 8 chars etc. (got about 150 rows of data) every row has the same fieldspecs. How would I go about it to import this data into a designated sheet from VBA? Using the wizard will open the file and place it on a new workbook and that's not what I want.. Thanks in advance for any pointers. -- Maurice |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fixed length file | Excel Discussion (Misc queries) | |||
fixed length file to excel? VBA macro possible? | Excel Programming | |||
Fixed length text file | Excel Discussion (Misc queries) | |||
Fixed length file import?? | Excel Programming | |||
2 Qs: grab net page, and import as fixed length format | Excel Programming |