vba string question. 1

[Junior1544]

I was just hopping that some one could tell me the limit of the number of char's i can put into a string variable...

I am working with an excel file and would like to put a bunch of information into the body of the email. in doing so I will need much more then the 255 that is a limit for text in access... I am working in excel and am looking for a solution... If i need to assign the value to a cell and work with it in there, it'll take me longer to write the code, but it'll all work out...

I would rather leave it in a variable then in code...

Thanks a bunch for the time...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[sfvb]

The maximum length for text in a cell is 32,767 characters.
The maximum length for a string using VBA is 2,147,483,648 characters.

In Access you could use the Memo data type instead of the Text data type. The max length for a Memo data type is 65,536 characters.

 

[Junior1544]

ok, a variable will be more then enough space...

Thank you.. here's a star for being an expert on the weekend!

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.