Procedure too large

Hello team VBA,

I have an issue with a procedure thats too large.

Within my wee "app" there are a few related procedures that I use as a almost a database, with just under a 1,000 items.

Problem is that I've essentially run out of room to add more stuff.

I've tried simply splitting it into smaller chunks but it errors out.


With Data2
.Data_2_stuff = "text"
.Data_2_more_stuff = "more text"
End With
Adddata2 Data2

Any ideas would be great thanks, as I need to add more elements.

I have previously split it up, which is how I wound up with #2, I dont really want to split it again...

Regards
Kes

If it's too large you are going to have to split it up some more, I cannot see any other option.

You do realize that word is not the proper program for a database.

I'm getting a vibe that you have just under 1000 pieces of data embedded in your macro and that you want to add more

Without seeing what you have, I think you'd be better off not using Word as a database like arnelgp says, but storing the 'data' somewhere else like a CSV or TXT file and read the file into memory when you need it