Consulting

Results 1 to 3 of 3

Thread: anybody have a Split() replacement?

  1. #1
    VBAX Regular
    Joined
    Jun 2004
    Location
    Los Angeles
    Posts
    22
    Location

    anybody have a Split() replacement?

    I'm trying to get an in-house excel plugin to operate on the macs we have. I've just figured out that the Split() function does not exist on the Mac version of VBA...

    (Split() takes a string and a delimiter, and returns an array of strings broken up by the delimiter.)

    Has anyone a version of Split() they wrote, or know of a public version?

    I could write one... but I'm hoping someone has an efficient version that they share.

    -Blakieto

  2. #2
    VBAX Regular
    Joined
    Jul 2004
    Location
    San Bernardino, California
    Posts
    69
    Location
    Try the example at this website - LINK

  3. #3
    VBAX Regular
    Joined
    Jun 2004
    Location
    Los Angeles
    Posts
    22
    Location
    Thanks!

    I've also located this:
    http://support.microsoft.com/default...b;en-us;188007
    Which contains source for Join, Split, InStrRev, Replace and Reverse functions.

    -Blakieto

Posting Permissions

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