• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.
  • Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel VBA File path length exceeds 255 characters

manish agarwal

New Member
Hi All,

I am trying to save a file on a Sharepoint location and the entire file path exceeds 255 due to which it does not work. I have searched a lot on google but could not find a workable solution. Hence eventually I had to come here at Chandoo's. Has someone faced similar issue and probably got a solution or workaround. I can think of mapping the sharepoint drive to make it short but this seems to be very old solution and complex. Also, I read about on a website (see below) but I think this does not work on VBA. Is there any other solution or can someone explain how we can simplify the old solution
Use the subst command like so:
subst X: "C:\Folder1\Really Long Path\Such Recursion\So Deep\Wow"


Have a read of the post at: