Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.outlook.program_vba,microsoft.public.word.vba.general
|
|||
|
|||
Excel-created Word instance hanging on thru Outlook?
This may be easier to resolve than it seems, because right now it looks like
a tangled mess! I'm using Word, Excel, and Outlook 2000. A macro in Excel gets or creates an instance of Word, sets an object to it, and then opens a Word doc. The Word application object is set with late binding (Dim WD As Object), rather than early binding to allow users of different versions to use the macro. The object is set to Nothing at the end of the macro. I have Outlook set to use Word as my email editor. If my Outlook is open, Excel sees that as an instance of Word and uses GetObject to create the Word object. I often get "leftover" Word instances that hang on when I close Outlook or Shut Down. Is there something peculiar to the way Outlook connects to Word that would cause this? Is there a better termination that would resolve this? Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invoice created from Excel ocr Access and sent via Outlook | Excel Discussion (Misc queries) | |||
Excel attachment in Outlook causing 2nd instance of Excel to open-help! | Excel Discussion (Misc queries) | |||
would like to export an address book created in excel to outlook | Excel Discussion (Misc queries) | |||
Get an object representing an existing Excel instance from Outlook | Excel Programming | |||
Exporting data to new instance of excel - created but not visible? | Excel Programming |