Macro to Access External Files
..txt files, .xls or anything else?
"Grumpy" schreef in bericht
oups.com...
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.
|