Macro to Access External Files

[Grumpy]

I have a file called, say . Within this file I want a macro that will
access other files (all in the same directory) all of which have the
same lay-outs, BUT have all sorts of different file names; Once the
choosen file has been selected I then want the macro to carry-on with
the processing of data from these files into the file.

How do I do this .... my limitations on macros is just above
'recording' level.

I'm using EXCEL 2000.

 

[moi]

..txt files, .xls or anything else?

 

[[G]rumpy [O]ld [D]uffer]

Using .xls files.