Loop opening workbooks run-time error '9' on workbook variable

  • I have a master workbook that loops through and opens workbooks one at a time.

    The code opens a workbook, refreshes links, saves, close. However, the macro errors out only on some workbooks. It opens the workbook, but fails to save the workbook.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!