How far can you macro?

[UniversalJOC]

I'm trying to establish whether I can create a marco that will open a folder and search for new files with a certain title? Is this possible? I then intend to create a further marco to open (the text file), delimit it and open it in an excel format. Can anyone enlighten me if this is possible?

 

[UniversalJOC]

Hi, a last for the time being...
Is there a way to stop the search running through one of the folders in the folder I have specified?

Now these files open from a text doc to excel, is there a way to delimit the file from 'tab' to other & '|'. So it opens looking good?