Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Using One Instance
1 view
Skip to first unread message
targante
Jul 30, 2009, 10:16:02 AM7/30/09
to
How do I get VB6 to use an already opened instance of Excel instead of it
opening a new one; and, if an instance is not open, to open one?
TIA,
Trent Argante
[DC.J(582)]
opening a new one; and, if an instance is not open, to open one?
TIA,
Trent Argante
[DC.J(582)]
Karl E. Peterson
Jul 30, 2009, 1:05:38 PM7/30/09
to
targante wrote:
> How do I get VB6 to use an already opened instance of Excel instead of it
> opening a new one; and, if an instance is not open, to open one?
> How do I get VB6 to use an already opened instance of Excel instead of it
> opening a new one; and, if an instance is not open, to open one?
As with any other COMponent, use GetObject first, and if that fails then use
CreateObject.
--
.NET: It's About Trust!
http://vfred.mvps.org
0 new messages