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

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
>

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
> >

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
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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
> >