Import space delimited text file into excel

Hi all,

I have a text file with 2 fields.
The 2 fields are space delimited.

I have the below code from google search,
It does not write the 2 fields into 2 columns.
Have attached the excel workbook and a sample file.

Please Login or Register  to view this content.

Some help on the above please.
Thanks.

If I read your macro correctly, you select a cell on your sheet manually, then run the macro and it's supposed to load the 2-column text file into your sheet at that point. If so, try this alternate method:

Please Login or Register  to view this content.

If you would rather explain the logic on how the macro might be able to find the proper place to insert the text without you having to manually select a cell first, do so and we can suggest a targeting method, too. For instance...first empty cell in column A.

Thanks for your responce.

I would liketo insert in the first cell of A, the first field and the second field in first cell of B.
I would also like to add a new sheet called Drawings and insert the value there.
Have not executed your code.
will give it a try and let you know.
Thanks

Originally Posted by vijay2482

I would like to insert in the first cell of A, the first field and the second field in first cell of B.

Then change the Destination code to read like so:

Please Login or Register  to view this content.

I would also like to add a new sheet called Drawings and insert the value there.

Please explain further. Is this in addition to above, a second insertion? Or is it instead of?

Does the "Drawings" sheet already exist? If not, should the macro create it? If it does exist, insert the data where?
Have not executed your code.
will give it a try and let you know.
Thanks[/QUOTE]

Please explain further. Is this in addition to above, a second insertion? Or is it instead of?

Does the "Drawings" sheet already exist? If not, should the macro create it? If it does exist, insert the data where?

The above code will be written in a module.
When the macro is run, it has to create a new sheet named drawings and the data has to be inserted in that sheet.
The drawings sheet will not be available already.