function "compile error msg: procedure too large"

[RASHESH]

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

 

[Guest]

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.

 

[Guest]

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!

 

[Guest]

Hi Rashesh,

Try exporting the modules, deleting them, then re-importing. That sometimes
helps.

Alok Joshi

 

[RASHESH]

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.

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.

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.