+ Reply to Thread
Results 1 to 8 of 8

Excel 218 character path limit workaround

  1. #1
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,601

    Excel 218 character path limit workaround

    I made an Excel application that generates pdf's. Now I ran into problems with long path names since the generated pdf's are to be stored further down in the folder hierarchy.

    I tried to generate the pdf to a temporary folder higher up in the hierarchy and then move them but Excel saw through that and refused.

    I'm trying to figure out a reasonably simple workaround. Wouldn't it be possible to make a really simple piece of code in some other language that can move the file and then call that from VBA?
    Last edited by Jacc; 10-06-2017 at 06:22 AM.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,128

    Re: Excel 218 character path limit workaround

    i write all my PDFs to folder: c:\temp\
    EVERYONE can have this, and it never fails.

  3. #3
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,601

    Re: Excel 218 character path limit workaround

    Well, the pdf's are expected to go in a specific folder in a hierarchy created for each project. I did some more googling and the consensus is that long path strings is a universally bad thing.
    It is now clear that our folder hierarchy name system needs a workover, some people have been vary generous with the number of characters for some folders and project names.
    Once this is corrected the 218 character limit won't be an issue.

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    9,832

    Re: Excel 218 character path limit workaround

    maybe it will help a little Max_Path
    sandy
    I want to see what you are trying to achieve, not how you are trying to do it
    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  5. #5
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,601

    Re: Excel 218 character path limit workaround

    Not sure what to make of that. What I can understand from other sources is that if you have windows10 and office 64 bit the path length is no longer an issue. Comments?
    However, with windows10 and office 32 bit the issue is not solved. Comments?

  6. #6
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    9,832

    Re: Excel 218 character path limit workaround

    I didn't say it is solution for everything but maybe it will help a little.

  7. #7
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,601

    Re: Excel 218 character path limit workaround

    My questions were more generic, not specifically related to your previous post.

  8. #8
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    9,832

    Re: Excel 218 character path limit workaround

    no problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA Workaround for 255 character limit in cell?
    By Bjordion in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-14-2013, 10:25 AM
  2. VBA formulaarray 255 character limit workaround
    By moses67 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2013, 06:41 AM
  3. Workbooks.opentext and Excel column limit..need workaround
    By enphynity in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2013, 07:58 AM
  4. [SOLVED] Workaround to the 32767 character limit for strings in VBA?
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-05-2013, 06:18 AM
  5. Workaround for HYPERLINK argument length limit
    By aboorkuma in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2012, 11:20 AM
  6. Workaround needed for 255 character find limit
    By NukedWhale in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-27-2009, 04:10 PM
  7. [SOLVED] Character limit in an Excel Row
    By Denise in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2005, 10:05 PM
  8. [SOLVED] busted workaround for 255 character limit in cells
    By mklapp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2005, 05:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1