J
JaneCranberry
I need to run a macro on hundreds of workbooks. I have the macro, but I can
not figure out how to access all these workbooks (in a folder) in one step.
In other words, I do not want to assign each workbook as a variable ... I
might as well open each manually and run the macro, as I have been.
Do I have to open all the workbooks first?
Can I write a macro that looks for a folder. selects the first workbook,
applies the macro, closes the workbook, selects the next workbook, applies
the macro ... etc.?
PLEASE I need to organize this data ASAP
Thank you
Jane Mika
Cranberry Station
UMASS
not figure out how to access all these workbooks (in a folder) in one step.
In other words, I do not want to assign each workbook as a variable ... I
might as well open each manually and run the macro, as I have been.
Do I have to open all the workbooks first?
Can I write a macro that looks for a folder. selects the first workbook,
applies the macro, closes the workbook, selects the next workbook, applies
the macro ... etc.?
PLEASE I need to organize this data ASAP
Thank you
Jane Mika
Cranberry Station
UMASS