Automation & Registry

[Guest]

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?

 

[Guest]

possibly:

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

Regards,
GS

 

[Guest]

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

 

[Guest]

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