Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.outlook.program_vba,microsoft.public.word.vba.general
Ed Ed is offline
external usenet poster
 
Posts: 399
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Invoice created from Excel ocr Access and sent via Outlook PeggyBell Excel Discussion (Misc queries) 1 April 20th 10 12:40 PM
Excel attachment in Outlook causing 2nd instance of Excel to open-help! Chet Excel Discussion (Misc queries) 1 December 18th 09 06:52 PM
would like to export an address book created in excel to outlook slowedog Excel Discussion (Misc queries) 2 February 23rd 08 01:55 AM
Get an object representing an existing Excel instance from Outlook R Avery Excel Programming 1 August 25th 04 11:16 PM
Exporting data to new instance of excel - created but not visible? Alan Excel Programming 4 July 19th 04 01:06 AM


All times are GMT +1. The time now is 07:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"