S
SteveDB1
Hello all.
On to the next step for my project.
As stated in other posts, I have approximately 800 workbooks in a single
folder. I've come up with a modification of macros provided by some of you.
It works perfectly-- for my purposes.
What I'd like to do next is to run this macro, automatcally, on all of the
800 files, one book at a time.
It seems to me that I'd need to open the file, call to my macros to run
(which is clear-- call MacroName), and then close the file. Then move on to
the next file, and repeat that process.
All of the files have the same first 4 characters, but different last
characters, and different length names.
I.e., ABC-xxxxx.xls*
I just did a count, there are 513 files, but the numeric count starts at
ABC-3 through ABC-750, give or take a bit.
Where x would be the last portion of the file name which would differ from
file to file, and the asterisk would make the file extension: xls, xlsx, or
xlsm. ABC- is constant throughout.
The goal of this macro would be to update, and reduce file "bloat", save,
and then move on to each subsequent file throughout the entire driectory.
The update, bloat reduction, and save to new xlsx format macros are already
working. I just need something to open, and then close all of the files in
the directory.
If this is not clear enough, please ask.
Thank you for your helps.
On to the next step for my project.
As stated in other posts, I have approximately 800 workbooks in a single
folder. I've come up with a modification of macros provided by some of you.
It works perfectly-- for my purposes.
What I'd like to do next is to run this macro, automatcally, on all of the
800 files, one book at a time.
It seems to me that I'd need to open the file, call to my macros to run
(which is clear-- call MacroName), and then close the file. Then move on to
the next file, and repeat that process.
All of the files have the same first 4 characters, but different last
characters, and different length names.
I.e., ABC-xxxxx.xls*
I just did a count, there are 513 files, but the numeric count starts at
ABC-3 through ABC-750, give or take a bit.
Where x would be the last portion of the file name which would differ from
file to file, and the asterisk would make the file extension: xls, xlsx, or
xlsm. ABC- is constant throughout.
The goal of this macro would be to update, and reduce file "bloat", save,
and then move on to each subsequent file throughout the entire driectory.
The update, bloat reduction, and save to new xlsx format macros are already
working. I just need something to open, and then close all of the files in
the directory.
If this is not clear enough, please ask.
Thank you for your helps.