Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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- - |
#2
|
|||
|
|||
"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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert value of a cell as a filename | Excel Worksheet Functions | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Add filename to footer before printing using VBA | Excel Discussion (Misc queries) | |||
Filename in a cell | Excel Worksheet Functions | |||
filename with folder | Excel Worksheet Functions |