| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro (open and save files with different drives) | Excel Discussion (Misc queries) | |||
| How can I save all open excel files? | Excel Discussion (Misc queries) | |||
| Fix for open/save files problem | Excel Discussion (Misc queries) | |||
| Macro to open *.dat files and save as .txt (comma delimited text files) | Excel Programming | |||
| Open Save & Close All Files in Dir | Excel Programming | |||
Threaded Mode
