View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
msdrolf msdrolf is offline
external usenet poster
 
Posts: 19
Default Macro to open, calculate, the save many files.

I would like to open, calculate, then close about 200 plus files. The files
are too large to open at once. I need to open one file, calculate, then
close it before opening the next file. The file names are in column A, the
path is the same for all files. I am guessing this involves an "array".
Unfortunately I haven't yet learned to work with arrays. Hope somebody can
help me. Thanks.