| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba,microsoft.public.word.vba.beginners,microsoft.public.word.vba.general
|
|||
|
|||
What's wrong during VBA project compilatrion?
Hi!
I've got a question: Is there any size limitations on VBA Project? Situation: I'm creating VBA classes and modules in MS Excel 2000 (9.0.2812) and after some additions(no matter what) I can't compile VBA project. There's an exception error signatu ----- AppName: excel.exe AppVer: 9.0.0.2719 ModName: vbe6.dll ModVer: 6.3.91.8 Offset: 00083676 ----- Thanks. -- Best Regards, Levan Jgarkava |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba,microsoft.public.word.vba.beginners,microsoft.public.word.vba.general
|
|||
|
|||
|
What's wrong during VBA project compilatrion?
Hi
have you tried exporting this code and importing it in a new workbook? If this does helpt maybe your current workbook is corrupt? -- Regards Frank Kabel Frankfurt, Germany "Levan Jgarkava" schrieb im Newsbeitrag ... Hi! I've got a question: Is there any size limitations on VBA Project? Situation: I'm creating VBA classes and modules in MS Excel 2000 (9.0.2812) and after some additions(no matter what) I can't compile VBA project. There's an exception error signatu ----- AppName: excel.exe AppVer: 9.0.0.2719 ModName: vbe6.dll ModVer: 6.3.91.8 Offset: 00083676 ----- Thanks. -- Best Regards, Levan Jgarkava |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba,microsoft.public.word.vba.beginners,microsoft.public.word.vba.general
|
|||
|
|||
|
What's wrong during VBA project compilatrion?
There are size limits, but you're unlikely to hit them. Compilation errors
are usually coding bugs that the compiler can't deal with, in my experience most commonly relating to procedure declarations. Try running the project without compiling and test thoroughly ... the bad code usually shows up pretty quickly. "Levan Jgarkava" wrote in message ... Hi! I've got a question: Is there any size limitations on VBA Project? Situation: I'm creating VBA classes and modules in MS Excel 2000 (9.0.2812) and after some additions(no matter what) I can't compile VBA project. There's an exception error signatu ----- AppName: excel.exe AppVer: 9.0.0.2719 ModName: vbe6.dll ModVer: 6.3.91.8 Offset: 00083676 ----- Thanks. -- Best Regards, Levan Jgarkava |
|
#4
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba,microsoft.public.word.vba.beginners,microsoft.public.word.vba.general
|
|||
|
|||
|
What's wrong during VBA project compilatrion?
Hi
have you tried exporting this code and importing it in a new workbook? If this does helpt maybe your current workbook is corrupt? A was coding in VB6, then I've created empty Excel Spreadsheet and imported a code as VBA project and then tried to compile but there was Excel crush. I tried to delete one function and code was compiled successfully, then I tried to uncomment this function and comment other function. code was compiled successfully, but when I tried to uncomment both functions, excell crashed down :( (I've tried also with another functions and the same thing happened)... Hi! I've got a question: Is there any size limitations on VBA Project? Situation: I'm creating VBA classes and modules in MS Excel 2000 (9.0.2812) and after some additions(no matter what) I can't compile VBA project. There's an exception error signatu ----- AppName: excel.exe AppVer: 9.0.0.2719 ModName: vbe6.dll ModVer: 6.3.91.8 Offset: 00083676 ----- Thanks. -- Best Regards, Levan Jgarkava |
|
#5
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba,microsoft.public.word.vba.beginners,microsoft.public.word.vba.general
|
|||
|
|||
|
What's wrong during VBA project compilatrion?
Hi,
There are size limits, but you're unlikely to hit them. Compilation errors are usually coding bugs that the compiler can't deal with, in my experience most commonly relating to procedure declarations. Try running the project without compiling and test thoroughly ... the bad code usually shows up pretty quickly. It doesn't seems as code problem. It's invariant to code content, but depends on code size... here's my answer to another respondent: A was coding in VB6, then I've created empty Excel Spreadsheet and imported a code as VBA project and then tried to compile but there was Excel crush. I tried to delete one function and code was compiled successfully, then I tried to uncomment this function and comment other function. code was compiled successfully, but when I tried to uncomment both functions, excell crashed down :( (I've tried also with another functions and the same thing happened)... Best Regards, Levan Jgarkava Hi! I've got a question: Is there any size limitations on VBA Project? Situation: I'm creating VBA classes and modules in MS Excel 2000 (9.0.2812) and after some additions(no matter what) I can't compile VBA project. There's an exception error signatu ----- AppName: excel.exe AppVer: 9.0.0.2719 ModName: vbe6.dll ModVer: 6.3.91.8 Offset: 00083676 ----- Thanks. -- Best Regards, Levan Jgarkava |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What's wrong during VBA project compilatrion?
The problem is that any changes to sub names or additions
that have cause to change sub names will eventually stop working as the original sub names are part of the modules thingy structure. To fix, copy and paste all code into a new module. This will reset the module thingy structure. In future, Name all of your objects before inserting code. Don't use the default names as a macro. regards Mark -----Original Message----- Hi! I've got a question: Is there any size limitations on VBA Project? Situation: I'm creating VBA classes and modules in MS Excel 2000 (9.0.2812) and after some additions(no matter what) I can't compile VBA project. There's an exception error signatu ----- AppName: excel.exe AppVer: 9.0.0.2719 ModName: vbe6.dll ModVer: 6.3.91.8 Offset: 00083676 ----- Thanks. -- Best Regards, Levan Jgarkava . |
|
#7
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba,microsoft.public.word.vba.beginners,microsoft.public.word.vba.general
|
|||
|
|||
|
What's wrong during VBA project compilatrion?
Your description makes it sound very much like a coding problem. Try
creating a second VBA project, copy the modules and functions bit-by-bit and try recompiling as you go. I think you'll find that these extra functions have something funny about their declarations; or as Frank suggested, you've got a corrupt module. "Levan Jgarkava" wrote in message ... Hi, There are size limits, but you're unlikely to hit them. Compilation errors are usually coding bugs that the compiler can't deal with, in my experience most commonly relating to procedure declarations. Try running the project without compiling and test thoroughly ... the bad code usually shows up pretty quickly. It doesn't seems as code problem. It's invariant to code content, but depends on code size... here's my answer to another respondent: A was coding in VB6, then I've created empty Excel Spreadsheet and imported a code as VBA project and then tried to compile but there was Excel crush. I tried to delete one function and code was compiled successfully, then I tried to uncomment this function and comment other function. code was compiled successfully, but when I tried to uncomment both functions, excell crashed down :( (I've tried also with another functions and the same thing happened)... Best Regards, Levan Jgarkava Hi! I've got a question: Is there any size limitations on VBA Project? Situation: I'm creating VBA classes and modules in MS Excel 2000 (9.0.2812) and after some additions(no matter what) I can't compile VBA project. There's an exception error signatu ----- AppName: excel.exe AppVer: 9.0.0.2719 ModName: vbe6.dll ModVer: 6.3.91.8 Offset: 00083676 ----- Thanks. -- Best Regards, Levan Jgarkava |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
| project | Excel Worksheet Functions | |||
| How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
| I pay $ for this project | Charts and Charting in Excel | |||
Linear Mode
