.Save, .Activate, .Close not working in Macro

[jstephens]

This is a weird problem, I'm hoping you guys can help. I've written a pretty basic macro to pull information from one workbook to the other. This part works perfectly fine, but any .Activate, or .Close function does not work. Application.Quit does not work as well (although that is not what I want it to do). I at first thought it was a problem with our remote management software, but a simple macro of "ActiveWorkbook.Close False" does in fact work all alone.

Here is the code:

Please Login or Register  to view this content.

Any suggestion on code optimization is appreciated, but I really need the opened workbook to close.

[Leith Ross]

Hello jstephens,

Welcome to the Forum!

With the exception of Application.Quit I don't see .Save, .Activate, or .Close in the code you provided. On potential problem I do see is that you exit the Sub with restoring screen updating.

Please Login or Register  to view this content.

Write a Sub to re-enable screen updating, and change your macro to re-enable screen updating before exiting. Rerun the macro and see if the changes help your problem.

[jstephens]

Hello jstephens,

Welcome to the Forum!

With the exception of Application.Quit I don't see .Save, .Activate, or .Close in the code you provided. On potential problem I do see is that you exit the Sub with restoring screen updating.

Please Login or Register  to view this content.

Write a Sub to re-enable screen updating, and change your macro to re-enable screen updating before exiting. Rerun the macro and see if the changes help your problem.

That's embarassing, I had just changed something because of that and didn't put two and two together. Thanks a lot!