| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
function "compile error msg: procedure too large"
HI,
CAN ANYONE HELP ME!!! I AM WRITING IN OFFICE XP EXCEL VBA FUNCTION, THIS FUNCTION IS DOING CREATE A ONE SHEET AND IMPORT FROM dBASE IV DBF FILE INTO EXCEL AND PARTICULAR SHEET FORMAT AND I AM CHANGING FONTS, ROW HEIGHT, CELL LOCK PROPERTY, COLUMN WIDTH, CELL NUMBERS FORMAT AND ETC. THIS ALL LINE ARE WRITE. THIS FUNCTION TOTAL LINES ARE 1125. IN MY CODE I CHEK EVERY LINES BUT NO ERRORS. PC CONFIGURE ---------------- WINDOWS XP OFFICE XP P4 1.5GHZ 512 BUS RAM 60GB HDD (10GB FREE) REGARDS RASHESH |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
function "compile error msg: procedure too large"
Hi Rashesh,
First of all, please turn off your Caps Lock. Thanks. Well, I've never seen that compiler error. I didn't know there was a size limit, but typically it's good practice to break up large routines into smaller functional units. Have you tried breaking up your procedure into pieces such as one sub to create the sheet, one to open and read database info, one to move data into the sheet, one to reformat cells, etc. Try that. "RASHESH" wrote: HI, CAN ANYONE HELP ME!!! I AM WRITING IN OFFICE XP EXCEL VBA FUNCTION, THIS FUNCTION IS DOING CREATE A ONE SHEET AND IMPORT FROM dBASE IV DBF FILE INTO EXCEL AND PARTICULAR SHEET FORMAT AND I AM CHANGING FONTS, ROW HEIGHT, CELL LOCK PROPERTY, COLUMN WIDTH, CELL NUMBERS FORMAT AND ETC. THIS ALL LINE ARE WRITE. THIS FUNCTION TOTAL LINES ARE 1125. IN MY CODE I CHEK EVERY LINES BUT NO ERRORS. PC CONFIGURE ---------------- WINDOWS XP OFFICE XP P4 1.5GHZ 512 BUS RAM 60GB HDD (10GB FREE) REGARDS RASHESH |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
function "compile error msg: procedure too large"
P.S. True story: at my last job I had to modify a program written by a
previous employee new to programming. It was written in Vax Basic (not Visual Basic) and was over 6000 lines of code, all one main routine, no subroutine calls at all!! It was HELL! "Charlie" wrote: Hi Rashesh, First of all, please turn off your Caps Lock. Thanks. Well, I've never seen that compiler error. I didn't know there was a size limit, but typically it's good practice to break up large routines into smaller functional units. Have you tried breaking up your procedure into pieces such as one sub to create the sheet, one to open and read database info, one to move data into the sheet, one to reformat cells, etc. Try that. "RASHESH" wrote: HI, CAN ANYONE HELP ME!!! I AM WRITING IN OFFICE XP EXCEL VBA FUNCTION, THIS FUNCTION IS DOING CREATE A ONE SHEET AND IMPORT FROM dBASE IV DBF FILE INTO EXCEL AND PARTICULAR SHEET FORMAT AND I AM CHANGING FONTS, ROW HEIGHT, CELL LOCK PROPERTY, COLUMN WIDTH, CELL NUMBERS FORMAT AND ETC. THIS ALL LINE ARE WRITE. THIS FUNCTION TOTAL LINES ARE 1125. IN MY CODE I CHEK EVERY LINES BUT NO ERRORS. PC CONFIGURE ---------------- WINDOWS XP OFFICE XP P4 1.5GHZ 512 BUS RAM 60GB HDD (10GB FREE) REGARDS RASHESH |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
function "compile error msg: procedure too large"
Hi Rashesh,
Try exporting the modules, deleting them, then re-importing. That sometimes helps. Alok Joshi "RASHESH" wrote: HI, CAN ANYONE HELP ME!!! I AM WRITING IN OFFICE XP EXCEL VBA FUNCTION, THIS FUNCTION IS DOING CREATE A ONE SHEET AND IMPORT FROM dBASE IV DBF FILE INTO EXCEL AND PARTICULAR SHEET FORMAT AND I AM CHANGING FONTS, ROW HEIGHT, CELL LOCK PROPERTY, COLUMN WIDTH, CELL NUMBERS FORMAT AND ETC. THIS ALL LINE ARE WRITE. THIS FUNCTION TOTAL LINES ARE 1125. IN MY CODE I CHEK EVERY LINES BUT NO ERRORS. PC CONFIGURE ---------------- WINDOWS XP OFFICE XP P4 1.5GHZ 512 BUS RAM 60GB HDD (10GB FREE) REGARDS RASHESH |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
function "compile error msg: procedure too large"
Thanks, for a guide to me
As u say I break a my procedure with section of work and my procedure run successfully work. Reagards Rashesh. "Charlie" wrote in message ... Hi Rashesh, First of all, please turn off your Caps Lock. Thanks. Well, I've never seen that compiler error. I didn't know there was a size limit, but typically it's good practice to break up large routines into smaller functional units. Have you tried breaking up your procedure into pieces such as one sub to create the sheet, one to open and read database info, one to move data into the sheet, one to reformat cells, etc. Try that. "RASHESH" wrote: HI, CAN ANYONE HELP ME!!! I AM WRITING IN OFFICE XP EXCEL VBA FUNCTION, THIS FUNCTION IS DOING CREATE A ONE SHEET AND IMPORT FROM dBASE IV DBF FILE INTO EXCEL AND PARTICULAR SHEET FORMAT AND I AM CHANGING FONTS, ROW HEIGHT, CELL LOCK PROPERTY, COLUMN WIDTH, CELL NUMBERS FORMAT AND ETC. THIS ALL LINE ARE WRITE. THIS FUNCTION TOTAL LINES ARE 1125. IN MY CODE I CHEK EVERY LINES BUT NO ERRORS. PC CONFIGURE ---------------- WINDOWS XP OFFICE XP P4 1.5GHZ 512 BUS RAM 60GB HDD (10GB FREE) REGARDS RASHESH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Compile error: Procedure too large? | Excel Discussion (Misc queries) | |||
| Procedure too large" error ...DAMN | Excel Programming | |||
| Compile Error: Procedure too large | Excel Programming | |||
| Getting "compile error" "method or data member not found" on reinstall | Excel Programming | |||
| the "Procedure too large" error | Excel Programming | |||
Linear Mode
