• 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

    Hui...

  • 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

M

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"

Regards,
Manish
 
Manish

Have a read of the post at:

Working with Paths over 255 characters - file count [SOLVED]

Hi All, I'm having some problems coming up with a work around for paths over the maximum character length. At present I'm getting a Runtime 76 - Path Not Found error. I know the ideal solution would be to get the excesive folder structure corrected but the user base is large and there...
www.excelforum.com
 
You must log in or register to reply here.
Back
Top