Prompt to Save Workbook After Using GetObject Function (115313)

WORKAROUND

To avoid receiving a dialog box with a message to save the file after you have activated a workbook as an OLE Automation object, close the workbook and use the xlfalse argument to avoid saving any changes, or the xltrue argument to save changes to the workbook. Note that when you use this method, Microsoft Excel remains running if it was running before you activated the OLE Automation object. The following is an example of using this method:

   ' Dimension variable xlsheet as object type
   Dim xlsheet As object
   ' Activate BOOK1.XLS and assign to variable xlsheet.
   ' Note: use the appropriate path for your file
   ' (this example assumes BOOK1.XLS has been saved in
   ' C:\EXCEL5\FILES).
   Set xlsheet = GetObject("C:\EXCEL5\FILES\BOOK1.XLS")
   ' Close workbook
   ' If Microsoft Excel is running when you run this procedure, the
   ' following statement does not close the application.
   ' If Microsoft Excel is not running when you run this procedure, the
   ' following statement closes the application.
   ' Use the xltrue argument in the following statement instead of
   ' xlfalse if you DO want to save changes to the file
   xlsheet.Parent.[close] xlfalse
   ' Quit Microsoft Excel
   Set xlsheet = Nothing
				

Note that the DisplayAlerts method does not work in this case to avoid the save changes dialog box.

Microsoft provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. This Visual Basic procedure is provided 'as is' and Microsoft does not guarantee that it can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose. Note that a line that is preceded by an apostrophe introduces a comment in the code--comments are provided to explain what the code is doing at a particular point in the procedure. Note also that an underscore character (_) indicates that code continues from one line to the next. You can type lines that contain this character as one logical line or you can divide the lines of code and include the line continuation character. For more information about Visual Basic for Applications programming style, see the "Programming Style in This Manual" section in the "Document Conventions" section of the "Visual Basic User's Guide."