Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tricky Macro Question | Excel Worksheet Functions | |||
Tricky counting question | Excel Discussion (Misc queries) | |||
Tricky comparing question | Excel Worksheet Functions | |||
Tricky Question | Excel Worksheet Functions | |||
Tricky Graph Question | Excel Programming |