Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 Macro
I am gettting the following error when trying to compile my excel macro.
"COMPILE ERROR: PROCEDURE TOO LARGE" How do I get around this error message and allow excel to compile my auto_open macro? Thanks in advance. Keven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 Macro
Break the procedure in to two or more smaller procedures,
passing, if necessary, variables from one procedure to the next. Good structured programming techniques would already lead you down this path. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Keven Swingle" wrote in message ... I am gettting the following error when trying to compile my excel macro. "COMPILE ERROR: PROCEDURE TOO LARGE" How do I get around this error message and allow excel to compile my auto_open macro? Thanks in advance. Keven |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 Macro
break up your code into more than one module.
-- Regards, Tom Ogilvy "Keven Swingle" wrote in message ... I am gettting the following error when trying to compile my excel macro. "COMPILE ERROR: PROCEDURE TOO LARGE" How do I get around this error message and allow excel to compile my auto_open macro? Thanks in advance. Keven |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 Macro
Hi keven
Adding to the others a small sample. Macros can /should be in separate modules: Sub Auto_open() Call PartOne Call PartTwo Call PartThree("Tada !") End Sub Sub PartOne() MsgBox "Hi" End Sub Sub PartTwo() MsgBox "Bye" End Sub Sub PartThree(strMsg As String) MsgBox strMsg End Sub HTH. Best wishes Harald "Keven Swingle" skrev i melding ... I am gettting the following error when trying to compile my excel macro. "COMPILE ERROR: PROCEDURE TOO LARGE" How do I get around this error message and allow excel to compile my auto_open macro? Thanks in advance. Keven |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 Macro
Thank you for the example, really helped to clarify what the others where
saying, I am very new to programming and greatly appreciate the assistiance. "Harald Staff" wrote: Hi keven Adding to the others a small sample. Macros can /should be in separate modules: Sub Auto_open() Call PartOne Call PartTwo Call PartThree("Tada !") End Sub Sub PartOne() MsgBox "Hi" End Sub Sub PartTwo() MsgBox "Bye" End Sub Sub PartThree(strMsg As String) MsgBox strMsg End Sub HTH. Best wishes Harald "Keven Swingle" skrev i melding ... I am gettting the following error when trying to compile my excel macro. "COMPILE ERROR: PROCEDURE TOO LARGE" How do I get around this error message and allow excel to compile my auto_open macro? Thanks in advance. Keven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro in Excel 2000 | Excel Discussion (Misc queries) | |||
Macro in Excel 2000 | Excel Discussion (Misc queries) | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Create macro to download access 2000 table to excel 2000 spreadsheet | Excel Programming | |||
Excel 2000 Macro | Excel Programming |