Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashes on copying macro using VBE.VBproject
Hello,
(Env excel 2003) I have developed the code that replicates the code (macors) from Workbook1 to Workbook2. Including code in modules, sheets and thisworkook object. When I run this code from within workbook1, it copies all the macro fine from Workbook2 to Workbook1. But when I move this code in an addin and try to replicate code from one Workbook to another excel crashes. The code triggers in 'workbook open' event of workbook1. From here a procedure in an addin is called that tries to replicate the code from WB1 to WB2. I have changed all the early bining to late binding all over my code whereever possible and fully qualified all the objects used in my code wherever possible. If anyone has experienced this or have any suggestion. Please let me know if more information is required. Thanks, Nayan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashes on copying macro using VBE.VBproject
Nayan,
I guess your problem is in your addin... try to check wether addin is protected in vbproject. or try to check the line of codemodule you wish to copy... and please post your error message while running code to copy entire module contents, so other people can see your problem. -- Regards, Halim "Nayan" wrote: Hello, (Env excel 2003) I have developed the code that replicates the code (macors) from Workbook1 to Workbook2. Including code in modules, sheets and thisworkook object. When I run this code from within workbook1, it copies all the macro fine from Workbook2 to Workbook1. But when I move this code in an addin and try to replicate code from one Workbook to another excel crashes. The code triggers in 'workbook open' event of workbook1. From here a procedure in an addin is called that tries to replicate the code from WB1 to WB2. I have changed all the early bining to late binding all over my code whereever possible and fully qualified all the objects used in my code wherever possible. If anyone has experienced this or have any suggestion. Please let me know if more information is required. Thanks, Nayan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 crashes on copying worksheet to new workbook | Excel Discussion (Misc queries) | |||
Excel crashes when copying to Word?? | Excel Discussion (Misc queries) | |||
Excel crashes when adding code using vbproject object? | Excel Programming | |||
Excel Crashes When Copying Multiple Sheets in VBA | Excel Programming | |||
Excel crashes when copying worksheets | Excel Programming |