VB 2005 Express DLL´s to VBA

[sebas_cp]

I just downloaded VB 2005 Express and would like to create some
financial functions to use within EXCEL through DLL´s but cannot
manage to do it. ANy help would be appreciated.

VB 2005 Express
Excel 2000
Windos 2000

cheers,
S

[m.posseth]

with VBA you can call COM components so if you create your .Net dll`with COM
interop it is no problem ata all
directly referencing the .Net dll without COM is not possible ( afaik )
regards

Michel Posseth [MCP]

<se******@hotmail.com> schreef in bericht
news:11**********************@o13g2000cwo.googlegr oups.com...
I just downloaded VB 2005 Express and would like to create some
financial functions to use within EXCEL through DLL´s but cannot
manage to do it. ANy help would be appreciated.

VB 2005 Express
Excel 2000
Windos 2000

cheers,
S

[sebas_cp]

Thanks for your answer. I have no experience with COM whatsoever. I
guess Ill keep using VB5 until I have time to sit and learn a bit more
about the the new versions.

regards,
S.

[CK Ong]

Hi Michel,

I am facing the same problem, whereby import Excel.dll to enable a connection to Excel properties. When I tried to declare the following statement in my VB Express 2005, it doesn't seem to recognize with error message as undefined.

"Dim Excel As New Excel.Application "

Thanks a lot.

Regards,
CK


************************************************** *****

with VBA you can call COM components so if you create your .Net dll`with COM
interop it is no problem ata all
directly referencing the .Net dll without COM is not possible ( afaik )


regards

Michel Posseth [MCP]

<[e-mail]> schreef in bericht
news:[e-mail] oups.com...
I just downloaded VB 2005 Express and would like to create some
financial functions to use within EXCEL through DLL´s but cannot
manage to do it. ANy help would be appreciated.

VB 2005 Express
Excel 2000
Windos 2000

cheers,
S