Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsVB SyntaxEnterprise DevelopmentDatabase AccessControlsCOMWin APICrystal ReportDeploymentGeneralGeneral 2
Related Topics
VB.NET / ASP.NETMS SQL ServerMS AccessOther Database ProductsMore Topics ...

VB Forum / COM / July 2009



Tip: Looking for answers? Try searching our database.

Using One Instance

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
targante - 30 Jul 2009 15:16 GMT
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)]
Karl E. Peterson - 30 Jul 2009 18:05 GMT
> 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.
Signature

.NET: It's About Trust!
http://vfred.mvps.org

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.