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?

Automation & Registry
 

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?

Automation & Registry
 

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

Automation & Registry
 

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.