Excel 2000 58 character Filename Limit?
That was for .Open, not sure for .SaveAs, but you could test.
Also, I have seen different behaviour using .SaveAs v. SaveCopyAs with
Unicode paths.
The former fails, the latter succeeds with exactly the same Path/Filename.
NickHK
"NickHK" wrote in message
...
You saving all these files with the same path also ?
Excel 2K will error on full path+filename over 218 chars.
Although not with that error, but 'File Cannot be found"
NickHK
"NickH" wrote in message
oups.com...
The thing is Dave, it only falls over when upgrading this one
particular workbook. Like I say, if I shorten the workbook's name to 58
characters or less it runs fine.
Other workbooks with equally long filenames, in the same format as
mentioned above (there are no non-alpha-numeric characters), don't have
a problem.
NickH
|