VBA to import text file into excel

[dshilan]

Hi,

I would like a macro that opens up File>Open and allows me to search for a file, then imports this data from the text file.

The data in the text file lots of rows, that will be in a1, b1, c1 etc...I already have a macro to format this, just would like to be able to import the data without having to copy and paste.

Also is it possible, when File>Open pops up on screen to open in a particular folder, ie c:\temp?

Thanks

[abousetta]

Are there any delimiters in the file (e.g. comma, space, tab)?

[dshilan]

Example of source file attached.

Cheers.