Adding code to workbook_open at runtime
How would one go about adding code to the thisworkbook object at runtime so
that a workbook_open macro is added. I want to be a able to create a
blank workbook, add data to it and then add a workbook_open macro that will
of course run when open. if it is not possible to add code to thisworkbook
object, is there another way to accomplish this. Any ideas? any links to
pages with working with vbaprojects?
thanks,
ben
|