Hello. Possibly an old theme, but with a slight variation.
I'm doing the finishing touches on an Excel-based app which is used for basic statistics with form automation of mail and email. The one thing I cannot overcome is manually closing a Word document which was opened by the Excel app, auto-populated with data using bookmarks, and then the human user types in the required postal address.
It has to be done in this manner as the users are required to read the document to check for errors, etc.
I've tried myDoc.Saved = True but if any manual alteration is made after the form has been opened, Windows does the Save Y/N thing.
Because Excel is the main program, I assume I can't add a module to insist that the save prompt or alerts for Word are turned off.
I can't really add Buttons in the Excel form, as this is already cluttered.
Any ideas on how to allow clicking the X to kill Word without the save dialogue?
Altering settings in Office may not be possible due to admin rights - it's a workplace environment.
Many thanks in advance.
Rich