Folks
Complete newbie but have picked up so much reading previous threads, hopefully someone can help with the following.
I have a master workbook which I control which when opened, opens another 10 protected workbooks and pulls over data that is collated in the master. The following extract carries out this task on one workbook.
Workbooks.Open Filename:="C:\01.xls", Password:="ab"
Workbooks("01").Close SaveChanges:=False
This works well and updates the master however I am then presented with a message box requesting I enter the password to open the above file “01”. Even though I press cancel the data is transferred as designed.
Is there a way to switch off this request to fully automate the process of updating the master spreadsheet.
Thanks
Bookmarks