Results 1 to 3 of 3

Thread: Split function for VB in Office 97

  1. #1

    Thread Starter
    New Member
    Join Date
    Dec 2002
    Posts
    2

    Lightbulb Split function for VB in Office 97

    Anyone an idea?
    I have some VB code I made in Office (2000 and XP). In this code I used the Split function for a string like "hi there, can, you, help, me?". By splitting it with split and as separator ", " I get my array like
    array(0) = "hi there"
    array(1) = "can"
    array(2) = "you"
    array(3) = "help"
    array(4) = "me?"

    I would like to create a similar VB script for the use in Office 97. Now I just found out that the Split function is not supported there. So I need to create a Split function for this.
    Since I am not real good at VB (yet?) I hope you have some suggestions or examples for me.
    If anything is not clear, just ask.

    Thanks a lot in advance ! And best wishes ! ;-)

  2. #2
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359

  3. #3

    Thread Starter
    New Member
    Join Date
    Dec 2002
    Posts
    2
    thanks a lot. That is what I was looking for.
    I am gonna try it.

    Thanks again !

Posting Permissions

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



Click Here to Expand Forum to Full Width