Dynamically Loading DLLs. Is it possible?

[Robert Fernando]

Hi,

I was wondering.. is it possible to dynamically load an ActiveX dll programmatically? i.e. Have no reference to it in the project but still be able to load it through code?

Thanks,

Rob.

[Lothar Haensler]

the Createobject function allows you to do that.
Set o = CreateObject("yourProgID")
e.g.
Createobject("excel.application")