Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'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- - |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
'ActiveWorkbook.SaveAs Filename'
Path length File
I think the limit is 255 or perhaps less. Apparently less based on the following http://support.microsoft.com/default...b;en-us;131464 "Filename Is Not Valid" Error Saving or Opening File -- Regards, Tom Ogilvy "TOMB" wrote in message ... 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- - |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
'ActiveWorkbook.SaveAs Filename'
Tom,
Thanks for the help. "Tom Ogilvy" wrote: Path length File I think the limit is 255 or perhaps less. Apparently less based on the following http://support.microsoft.com/default...b;en-us;131464 "Filename Is Not Valid" Error Saving or Opening File -- Regards, Tom Ogilvy "TOMB" wrote in message ... 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- - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max charactors for 'ActiveWorkbook.SaveAs Filename'? | Excel Worksheet Functions | |||
ActiveWorkbook.SaveAs Problem | Excel Programming | |||
activeworkbook.saveas | Excel Programming | |||
Error on ActiveWorkbook.SaveAs method | Excel Programming | |||
Error on ActiveWorkbook.SaveAs method | Excel Programming |