Hi,

I'm trying to write a vba macro to open all the .txt files in a given folder and to open them as space delimited with consecutive delimiter. How can I do this? I came across a similar thread here http://www.excelforum.com/excel-prog...ext-files.html re: semi colon delimited files but I'm very new to this and I can't work out how to change the code from semi colon to space.

If any of you guys can help me ASAP it'd be much appreciated...and you may be get a mention on my thesis acknowledgements