>>Hi everybody,
>>
>>In the CombineXLSFiles function I have a limitation of 31 chars for the name of the spreadsheet. Is it a valid limitation or longer names can be used?
>>
>>Thanks in advance.
>
>
>
>It is valid.
>Even in Excel itself you can't use more than 31 chars to name a sheet.
Where is the limitation come from and how should I code around it?
I don't see it here
http://office.microsoft.com/en-us/excel/HP051992911033.aspx
If it's not broken, fix it until it is.
My Blog