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.

    Code
    Workbooks(myfilename).Activate


Participate now!

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