not sure if that's possible on initialize?
have you tried using a property name?
myClass.myWKS = workbookname
or instead of trying to do this at initialisation, have a wookbook prop_name
and then call a method in your class which calls the prop_name.
I don't think you can do overloading in VBA (just started
vb.net and the book says
overloading is new to
vb)
HTH
alun