Macro now requires file extension entered to open document
Hello, Let me start by stating that I do not know VBA, but I am considered the troubleshooter when something goes wrong. I work for a small manufacturer, and we create a document for each part that outlines what needs to be done. We have a relatively simple macro that we have been using for the last 11 or 12 years. It basically opens a document, then uses find and replace to change a couple of text fields, prints and closes it without saving. The document is opened by entering the file name only with no file extension. Up until this week it was working perfectly, but now the only way to get it to work is to enter the filename AND the extension. It seems a recent office update has changed something to cause this. This was discovered accidently by trying the macro on another computer and it worked without entering the file extension. We discovered that PC has office version 16.0.8431.2153, and the other PC has version 16.0.11328.20392. Having to enter an additional 4 keystrokes is cumbersome and time-consuming. I'm hoping that someone can advise me on how to get the macro to work as it has previously. I've attached the complete macro for review, and lastly, the documents we use are all in Word97 format (*.doc). Thank you for your help!
|