M
Maurice
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.
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.