Results 1 to 10 of 10

Anyone know how to get around the max string size in VBA editor?

Threaded View

  1. #1
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Anyone know how to get around the max string size in VBA editor?

    Anyone know how to get around the max string size in VBA editor?

    I need to build a string that is over 5000 chars inside the editor. Anyone know a way to achieve this?
    Last edited by JapanDave; 07-09-2017 at 06:12 PM.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to change the VBA Editor's font size?
    By Mariano B. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2020, 12:03 AM
  2. Max string size / best way to loop through 200k rows
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2017, 06:51 AM
  3. [SOLVED] How to return a string of unknown size from DLL to Excel Visual Basic in C ?
    By u24c02 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-15-2017, 11:44 AM
  4. [SOLVED] extract multi-letter string bits from string depending on size and case
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-18-2017, 10:41 PM
  5. split of string with multiple section of various size spaces
    By katto01 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-29-2013, 04:50 PM
  6. VBA String Editor For Excel 2007
    By GWilliams in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2009, 03:52 PM
  7. Excel 2007 : VBA String Editor For Excel 2007
    By GWilliams in forum Excel General
    Replies: 0
    Last Post: 04-07-2009, 12:42 PM

Tags for this Thread

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