Solved: Document File Size

[MOS MASTER]

What are you trying to prove?
You've already been told that a string can hold about 2 billion characters.

Haha that's true..good one Howard, forgot about the previous bitt off this questionne...

@Dave
So if you use the LEN function on the text you want to load in to the string you can deside to use the Mid (Left, Right, etc..) Function if need be to pass Substrings in to other string variabels to hold the values en concenate them in the document.

But I think you should just code you're program and come over here with the code if you run into problems!

[Dave]

"You're string doesn't overflow it's you're counter witch is declared as Integer!"
Now that is funny. Appearances can be deceiving. Some days you learn more than others. Not trying to prove anything. Just trying to prevent crashes if an overflow error occurs. This was just a feeble start and somewhat amusing I'll admit. The notion was to always have a backup copy of the string so when it overflowed you could copy the backup to Word, reset the error, set the original string to vbnullstring, then return to the routine and continue on with what you were doing like nothing happened. It needs a bit of work. However, it's been about 15 minutes since I set the above code loose on a long variable and still no message. It's hard to grasp what 2 billion characters will do for you. More than likely adequate for what I'm doing. I think I'll mark this as solved as the effort isn't worth the gain. Very much appreciate all the help. Dave

[MOS MASTER]

"You're string doesn't overflow it's you're counter witch is declared as Integer!"
Now that is funny. Appearances can be deceiving. Some days you learn more than others.
Very much appreciate all the help. Dave

Hi Dave,

You're welcome and glad you have as much fun as I have!