1202
Chapter 44 Advanced VBA Tools and Techniques
■ When you leave a procedure that’s been manipulating Word via CreateObject(), Word
stays visible on the screen, and any documents you have opened remain open. Excel, on
the other hand, disappears.
■ Most frustrating of all, Word documents that have been created or opened via
CreateObject() remain open after the program finishes. In Excel, if the program stops,
all the open workbooks disappear. You must save Excel workbooks before exiting or all
the changes will be lost.
Office isn’t the only “exposed” application. Windows XP and Windows 2000 include the
Windows Scripting Host, which offers a huge library ...