LeonIRL
07-29-2008, 06:27 AM
Hi all,
I have been given the task of creating a message box which will appear whenever a user saves a file with any of the Office 2007 applications.
This dialog box will simply give the user a reminder to save it in the correct format (new Office 2007 format for internal company use, and older Office 2003 format for external use to ensure backward compatibility).
My question is; Is there a way to create a simple message box once the user has pressed Save -> Save as Word Document (the default format, regardless of what it is), with VBA?
Is VBA the route to go?
Regards,
Leon
H.J. Lyons & Co.
I have been given the task of creating a message box which will appear whenever a user saves a file with any of the Office 2007 applications.
This dialog box will simply give the user a reminder to save it in the correct format (new Office 2007 format for internal company use, and older Office 2003 format for external use to ensure backward compatibility).
My question is; Is there a way to create a simple message box once the user has pressed Save -> Save as Word Document (the default format, regardless of what it is), with VBA?
Is VBA the route to go?
Regards,
Leon
H.J. Lyons & Co.