Macro to Access External Files

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.

..txt files, .xls or anything else?


"Grumpy" <[email protected]> schreef in bericht
news:[email protected]...
>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.
>

Using .xls files.

"moi" <coffeecop@_NOSPAM_planet.nl> wrote in message news:<[email protected]>...
> .txt files, .xls or anything else?