search folders/open files

  • Thread starter Thread starter auujxa2 via AccessMonster.com
  • Start date Start date
A

auujxa2 via AccessMonster.com

My company currently has a manual process that needs to be updated.
Basically, I get sent an excel file every month - and with that file, I need
to update a bunch of other excel files within a bunch of folders/subfolders.

So:
1-copy range in excel
2-search/open file in folder/subfolders
3-paste copied range in cell A6
4-save
loop until all files are updated.

any direction someone can give would be GREATLY appreciated. thank you
 
I should add to this:

i do have VBA experience, so I'm trying to find code snipets to plug in to
accomplish this. thank you
 
Back
Top