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

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
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."
 
L

Legacy 98055

Guest
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,504
Messages
5,832,106
Members
430,111
Latest member
Francis Xavier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top