+ Reply to Thread
Results 1 to 2 of 2

Workbooks.opentext and Excel column limit..need workaround

  1. #1
    Registered User
    Join Date
    12-21-2006
    MS-Off Ver
    Office 2013
    Posts
    73

    Workbooks.opentext and Excel column limit..need workaround

    So I have a file that I am opening with "workbooks.opentext", but the data in the file (it's an EDI payment file) is one very long line so when excel opens it the data exceeds the Excel column limit so that when the data gets transposed there is data missing at the bottom. Is there any way around this?
    Last edited by enphynity; 08-08-2013 at 11:22 PM.

  2. #2
    Registered User
    Join Date
    12-21-2006
    MS-Off Ver
    Office 2013
    Posts
    73

    Re: Workbooks.opentext and Excel column limit..need workaround

    bump..................

+ 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] 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
  2. Workaround for HYPERLINK argument length limit
    By aboorkuma in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2012, 11:20 AM
  3. user select for "workbooks.opentext" excel feature
    By karl1985 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2010, 07:26 AM
  4. 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
  5. 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