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.
|