Automation & Registry

Using the automation object (xl) from VB i.e.

set xl = CreateObject("Excel.Application")

How can I call the registry functions, SaveSettting and GetSetting, in Excel?

possibly:

xl.SaveSetting...
xl.GetSetting(...)

Regards,
GS


"AA2e72E" wrote:

> Using the automation object (xl) from VB i.e.
>
> set xl = CreateObject("Excel.Application")
>
> How can I call the registry functions, SaveSettting and GetSetting, in Excel?

No!
These are VBA functions and not part of the Excel Object i.e. they are not
methods.

Yes, you're right. In this case, it may need a reference to the application's
VBA library. Something like

xl.VBA.GetSetting(_,_,_,_)
xl.VBA.SaveSetting _,_,_,_
possibly!

Regards,
GS


"AA2e72E" wrote:

> No!
> These are VBA functions and not part of the Excel Object i.e. they are not
> methods.