Macro for changing all files in directory

  • Thread starter Thread starter Drew
  • Start date Start date
D

Drew

I have about 60 excel files that I need to change, all of the files are a
directory. The change that needs to be made is making each workbook shared
and changing some of the tracking changes settings. How can I make a macro
to take a path and open all excel files (one at a time), make the changes,
then save and close the file?

Thanks,
Drew
 
Here are the changes that need to be made,

With ActiveWorkbook
.AutoUpdateFrequency = 5
.AutoUpdateSaveChanges = True
.KeepChangeHistory = True
.ChangeHistoryDuration = 60
End With
ActiveWorkbook.ProtectSharing

Thanks,
Drew
 
Back
Top