Max charactors for 'ActiveWorkbook.SaveAs Filename'?
 

Is there a maximum number of charactors that VBA will recognize for
'ActiveWorkbook.SaveAs Filename'?

I have code which used to update several (excel) files then save them to a
network file server. We have recently been required to migrate to a new
network directory/folder structure which contains 160 plus charactor naming
convention. I have made the appropriate changes to point to the new location,
but now I get an error which shuts down Excel.

Could the length of the file server/folder name be too long for Excel/VBA to
recognize?

Thanks for any insights

- -TB- -

"TOMB" wrote...
Is there a maximum number of charactors that VBA will recognize for
'ActiveWorkbook.SaveAs Filename'?
....

218 characters. I read this in the Runtime error 1004 dialog.