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

http://www.cpearson.com/excel/vbe.htm

that link works fine, I love answering my own questions. :-p thanks anyway
for anyone who looked

"ben" wrote:

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