Search:  
NamespacesDiscussions.NET v1.1Feedback
External dll in excel
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-msoffice' list.


Julio Novo
-- Moved from [ngfx-oledb] to [ngfx-msoffice] by Marcie Jones <Click here to reveal e-mail address> --

Hi, I need to use one external dll to obtain data into an excel sheet. My
dll on vb work fine, and returns the data. So, I need to know how to link
excel macros to my outsider dll? Can any help me to link excel macro to this
dll?
Regards, Julio

_________________________________________________________________
Hable con sus amigos en línea, pruebe MSN Messenger: http://messenger.msn.es
Reply to this message...
 
    
Scott Hutchinson
If the external DLL is a COM DLL (such as those created in VB), then you can
add a reference to it in your Excel VBA project from the Tools...References
menu item.

If it's not a COM DLL, then you would use DECLARE statements in a VBA module
just as you would in VB.

Scott Hutchinson
Click here to reveal e-mail address
(to contact me, remove all dots left of @)

"Julio Novo" <Click here to reveal e-mail address> wrote in message
news:672314@ngfx-msoffice...
[Original message clipped]
Reply to this message...
 
    
Julio Novo
Thanks, My Dll is a Com Dll created in C++, using the HttConn api. therfore
I can add a reference

Regards, Julio

----- Original Message -----
From: "Scott Hutchinson" <Click here to reveal e-mail address>
Newsgroups: ngfx-msoffice
To: "ngfx-msoffice" <Click here to reveal e-mail address>
Sent: Wednesday, June 19, 2002 11:03 PM
Subject: [ngfx-msoffice] Re: External dll in excel

> If the external DLL is a COM DLL (such as those created in VB), then you
can
> add a reference to it in your Excel VBA project from the
Tools...References
[Original message clipped]
Reply to this message...
 
 




Ad
MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT
 
 Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com