Max size (bytes) of data stored in a workbook name?

[Legacy 98055]

Office 97 on up...

Thanks!

 

[RalphA]

For Excel 97, Help, Workbook let me see the following:

"Guidelines for naming workbooks

To make it easier to find your workbooks, you can use long, descriptive file names. The complete path to the file, including drive letter, server name, folder path, file name,and a three-character file name extension, can contain up to 218 characters. File names cannot include any of the following characters: forward slash ( / ), backslash ( \ ), greater-than sign ( > ), less-than sign ( < ), asterisk ( * ), question mark ( ? ), quotation mark ( " ), pipe symbol ( | ), colon ( : ), or semicolon ( ; ).

If you work with other programs that do not support long file names, you should limit file names to eight characters."

 

[Legacy 98055]

Thanks Ralph.

I should have been more descriptive. If, for example, I was storing an array in a Workbook.Name object. The total number of bytes allowed. As in Len(Variable). I did find an answer.

Excel 97 and 2000 256 max Columns with a max total of 5561 elements.

In XP and 2003 you are limited only by the amount of memory.

Thanks,

Tom