• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Pull Balances

Hi:

Not sure why this is happening.

You have performed all the steps Chihiro as asked you to do.

  1. You know the error is on the line wb.close.
  2. We are using the prefix wb to call the active workbook and the code is running fine on another machine.

The only thing you can test is on the last point of Chihiro, check whether any other excel application was opened at the time of running the code.

Thanks
 
Thought you may like to know... I eventually figured this out. In the VBA Project window Tools > Options > General Tab there are 3 Error Trapping options. Somehow mine was changed to "Break on All Errors". Once I changed it to "Break on Unhandled Errors" it works perfectly fine.

So glad I didn't have to uninstall and reinstall the entire Office 365 suite.
 
You must log in or register to reply here.
Back
Top