Hello,
When automating SaveAs in a macro, how do I stop the app switching focus to the new file? I want to do some more processing with the source file after I've saved it as the new file but I keep losing focus. And if I call
Application.Workbooks("newfilename").Close, it closes everything.
Help appreciated - thanks!
When automating SaveAs in a macro, how do I stop the app switching focus to the new file? I want to do some more processing with the source file after I've saved it as the new file but I keep losing focus. And if I call
Application.Workbooks("newfilename").Close, it closes everything.
Help appreciated - thanks!
