I have VB6 code that creates Excel v8 workbooks/worksheet/controls/macros
based
upon a text file.
I have created a button on a worksheet that activates a piece of code.
Unfortunately, the code requires the CodeModule object which is part of the
'Microsoft Visual Basic for Applications Extensibility'.
Since I don't want the users having to add the reference before they can
click the button, how do I ensure that the reference is loaded each time the
newly-built workbook is loaded?
Regards, Darren
based
upon a text file.
I have created a button on a worksheet that activates a piece of code.
Unfortunately, the code requires the CodeModule object which is part of the
'Microsoft Visual Basic for Applications Extensibility'.
Since I don't want the users having to add the reference before they can
click the button, how do I ensure that the reference is loaded each time the
newly-built workbook is loaded?
Regards, Darren