Exactly how should the MyAddIn instance be declared?
I tried all sort of things without any luck.

Say I have a xla file "COMMON.xla" with a module Log where I among
others have a public function writeLog() that I would like to access
from a different workbook/sheet
The COMMON.xla also have the class module <properties that I would like
to set up a reference to within my workbook/sheet.

How would I do this?

code example:

public MyAddIn ???
public Props As MyAddIn.properties

public sub someFuncion()
Props = new MyAddIn.properties

Props.<some_access_method

MyAddIn.writeLog("some string")

end sub


cheers,
g

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!