Sorry if this message has been repeated

Exactly how would you go about setting up a reference to MyAddIn?

Lets say you have an addin calles COMMON.xla with the class module
properties and the module Log.
The Log has a public function writeLog(str as String) that you want to
access from any workbook/sheet


Example:

Public MyAddIn ??? 'how to setup this reference to COMMON.xla?

Props as MyAddIn.properties

public Function someFunction() as boolean
Props = new MyAddIn.Properties

some_property = Props.<some access method_or_property

MyAddIn.Log.writeLog("some string") 'is this correct?

End Function

cheers,
g

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