D
davegb
I am writing/recording a macro to make changes in 64 different
spreadsheets in 64 different folders on a network. I am just learning
vba. I don't know how to tell Excel to move through the 64 folders,
test for the spreadsheet to be sure it's there, then make changes. Most
of the changes will be easy to do as I will just record them while I
make them. The one change that I don't know how to make is to copy a
series of long descriptions from one spreadsheet into all of the
others. Any suggestions?
TIA
Dave
spreadsheets in 64 different folders on a network. I am just learning
vba. I don't know how to tell Excel to move through the 64 folders,
test for the spreadsheet to be sure it's there, then make changes. Most
of the changes will be easy to do as I will just record them while I
make them. The one change that I don't know how to make is to copy a
series of long descriptions from one spreadsheet into all of the
others. Any suggestions?
TIA
Dave