• Split Function in VBA 97 (Office 97 VBA)

    Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » Split Function in VBA 97 (Office 97 VBA)

    Author
    Topic
    #360739

    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.

    Viewing 0 reply threads
    Author
    Replies
    Viewing 0 reply threads
    Reply To: Split Function in VBA 97 (Office 97 VBA)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: