![]() |
New guy with a tricky question
Hello all!
I am working with Toolbook and excel, or more specifically, with openscript and excel. I am having a problem with getting hold of an existing instance of excel, and I've done lot's of searching and found the solutions that would work if I was in C# or VB.... but, Here's the glitch, I need a COM function to get the instance, and for the life of me, the only thing I can find is getObject, which I can't pull into my script. Does anyone know of a COM function that could get me a reference to an excel instance? Thanks, Arian Goodwin |
New guy with a tricky question
Toolbook from Asymetrix?
http://www.toolbook.org/cgi-bin/index.cgi -- Regards, Tom Ogilvy "Arian Goodwin" wrote in message ups.com... Hello all! I am working with Toolbook and excel, or more specifically, with openscript and excel. I am having a problem with getting hold of an existing instance of excel, and I've done lot's of searching and found the solutions that would work if I was in C# or VB.... but, Here's the glitch, I need a COM function to get the instance, and for the life of me, the only thing I can find is getObject, which I can't pull into my script. Does anyone know of a COM function that could get me a reference to an excel instance? Thanks, Arian Goodwin |
New guy with a tricky question
http://www.toolbook.com
In this example for OpenScript they use aObj = createAutoObject("OUTLOOK.application") so for excel it would be: aObj = createAutoObject("Excel.application") http://kb.sumtotalsystems.com/commun...09664911000032 -- Regards, Tom Ogilvy "Arian Goodwin" wrote in message ups.com... Hello all! I am working with Toolbook and excel, or more specifically, with openscript and excel. I am having a problem with getting hold of an existing instance of excel, and I've done lot's of searching and found the solutions that would work if I was in C# or VB.... but, Here's the glitch, I need a COM function to get the instance, and for the life of me, the only thing I can find is getObject, which I can't pull into my script. Does anyone know of a COM function that could get me a reference to an excel instance? Thanks, Arian Goodwin |
New guy with a tricky question
Thanks Tom, I appreciate the input, but the problem that I'm running
into is that this creates a new instance of Excel, and I need to get a hold of an existing instance. And I've seen answers to this in VB and C#, but I need a COM object that can do it. |
All times are GMT +1. The time now is 11:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com