PDA

View Full Version : anybody have a Split() replacement?



Blakieto
08-02-2004, 11:13 AM
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

ALaRiva
08-02-2004, 11:37 AM
Try the example at this website - LINK (http://www.utteraccess.com/forums/showflat.php?Cat=&Board=codearchive&Number=119662&Forum=f48&Words=split&Searchpage=0&Limit=25&Main=119662&Search=true&where=bodysub&Name=&daterange=0&newerval=1&newertype=m&olderval=&oldertype=#Post119662&bodyprev=)

Blakieto
08-02-2004, 11:58 AM
Thanks!

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

-Blakieto