Code not executing between File Open and File Save As

**gshockxcc** · 12-20-2023, 09:37 AM

I have the following code, which seems to be working property in segments. The File Open/File Save As seems to be working, but the code in the middle to resize the images isn't. I think the document is being closed with the Save As, and I'm not keeping it as the Active Document after the File Open. I'm not sure exactly how to do that.

If I comment out the File Open and File Save As code, I can resize the images as intended by the middle section of code. So, if I'm in the Normal.dotm document, and I'm opening another document to act on it, how do I make that (the opened document) the Active Document for the macro?

Please Login or Register  to view this content.

**sudbhavani** · 12-21-2023, 03:36 AM

It looks like you're on the right track, but you're correct in identifying the issue with the Active Document. After opening a new document, you need to set it as the Active Document so that subsequent operations are performed on it. Here's an updated your code:

Please Login or Register  to view this content.

This code opens the selected file, sets it as the Active Document, resizes the images, saves the changes, and then proceeds with saving the active document as .docm. If you want to close the opened document afterward, you can uncomment the openedDoc.Close line.