how i can know the limitation in the path, filename length in xls

[Tal]

We have encountered a strange situation; it seems MS Excel has a limitation
in the path + filename length. We conducted some tests and got conflicting
results, for example on my machine I was able to save with filenames of max
150 characters while on my colleague's machine around 200 characters. We did
not find any authoritative documentation on the subject.



Can you please help

 

[Rob Bovey]

We have encountered a strange situation; it seems MS Excel has a
limitation
in the path + filename length. We conducted some tests and got conflicting
results, for example on my machine I was able to save with filenames of
max
150 characters while on my colleague's machine around 200 characters. We
did
not find any authoritative documentation on the subject.

Hi Tal,

The only limitation I'm aware of is imposed by the Windows operating
system, in which the combined length of the path and filename cannot exceed
260 characters.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Ken Wright]

"Filename Is Not Valid" Error Saving or Opening File
http://support.microsoft.com/default.aspx?scid=kb;en-us;131464

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Tal]

Dear Ken,
The link that you provided to me was somehow helpful, and sorry that in the
previous post i didn't specify that i'm using the office 2003. but still the
problem is not solved.
Thanks,
Tal