Using VBA to write VBA code in ThisWorkbook causes exe error

[Vlip]

Hello,

I am using the following construct:

ActiveWorkbook.VBProject.VBComponents("ThisWorkbook").CodeModule.InsertLines 1, code

where code is VBA code. This works fine when using a sheet such as "Sheet1" but when using "ThisWorkbook", Excel dies with the message Excel.exe has generated errors and will be closed by windows.

I need to put the code in "ThisWorkbook" because it is a Workbook_Open procedure.

Anyone have any advice?
Thanks,
Vlip

 

[stdz]

Hello Vlip,

If the code has to go into a Workbook_Open procedure, why do you need to add it, via VBA ? Why don't you just code it directly into the workbook (in the Workbook_Open procedure) just like any other normal code ? What's the difference ?

Ciao,

Don.