View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
moi moi is offline
external usenet poster
 
Posts: 27
Default 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.