asked on Override for 218 character limit for filename & path when saving through VBA
I have a macro that publishes a PDF file and saves it to a shared directory. The filepath is quite long and I often run into the situation where the filename and path exceed the 218 character limit set in Excel. Is there a workaround for this? I am unable to use relative paths since this will be used by multiple users that may have the drives mapped differently.
Microsoft ExcelVBAWindows OS
Last Comment
bbao
Change the file naming policy, I do not see many other solutions
DON'T. Shorten the filenames, else you be back saying something else does not work. Filenames that are too long is a universally bad idea.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
It doesn't seem possible
https://support.microsoft.com/en-us/kb/213983
Regards