Dear Todd
The classname is usually a string referring to your object, rather than
the GUID.
For example:
CreateObject("MyLibrary.MyClass")
But this requires variants and dirty late binding.
An easier way to create COM objects (with what I think is early binding)
in Excel is as follows:
1. In Excel, open the VB editor (Alt + F11)
2. Open the Object Browser (F2)
3. Right Click on the "All Libraries" combo box and click
"References..."
4. Find your object in the list and check it
If you don't see it in the list, try clicking "browse..." and find your
dll on the file system.
If you can't find your object in the list it is probably not registered,
register it with Regsvr32.exe or in Delphi.
5. Use the "All Libraries" dropdown box to select your library
You should now be able to browse your objects and instantiate them
natively in Excel using their real names.
Dim x As MyLibrary.MyClass
Set x = New MyLibrary.MyClass
> -----Original Message-----
> From: Todd Martin [mailto:[EMAIL PROTECTED]
> Sent: Monday, 21 July 2003 2:20 p.m.
> To: Multiple recipients of list delphi
> Subject: [DUG]: Any COM Experts
>
>
> Hi all
>
> I've created a COM server object (*.dll) which I want to use
> in an Excel. So I was trying to use VBA CreateObject() with
> the COM interface GUID as the string parameter, but that doesn't work.
>
> Do I need to creat an Automation Server object instead and
> somehow register a class name for the dll in order to create
> it in a MS Office application?
>
> Thanks,
> Todd.
>
>
> --------------------------------------------------------------
> -------------
> New Zealand Delphi Users group - Delphi List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
> Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
