Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Colorado, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Split Function in VBA 97 (Office 97 VBA)

    I have developed a set of tools in Office 2000 VBA that I now need to port back to Office 97. The one problem I've encountered in this adventure is the split function. It apparently is new to Office 2000. FWIW, the function accepts a string and a character as arguments and reads the string generating a one dimensional array of items that were separated by the character in the input string. Has anyone written a function like this before that would be willing to share it or do I need to get to coding? Also, how does one find out which library provides a given function?

    Thanks.

  2. #2
    Rob Bruce
    Guest

    Re: Split Function in VBA 97 (Office 97 VBA)

    <P ID="edit" class=small>Edited by gwhitfield on 25-Sep-01 07:09.</P>Geoff W - hyperlinked

    Take a look at this MSKB article: <A target="_blank" HREF=http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q188007>HOWTO: Simulate Visual Basic 6.0 String Functions in VB5</A>

    This should provide you with what you need.

    You can use the object browser to search for members of object libraries.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split Function in VBA 97 (Office 97 VBA)

    For Excel, this extract function is handy
    <A target="_blank" HREF=http://www.j-walk.com/ss/excel/tips/tip32.htm>http://www.j-walk.com/ss/excel/tips/tip32.htm</A>

Posting Permissions

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