ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   New guy with a tricky question (https://www.excelbanter.com/excel-programming/345211-new-guy-tricky-question.html)

Arian Goodwin

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


Tom Ogilvy

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




Tom Ogilvy

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




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