Function to build string from array...

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Matthew Wells
    #1

    Function to build string from array...

    I can't remember what it is. The opposite of

    dim vArray as variant

    vArray = Array(1,4,7)

    creates a 3 element array of those values, but what builds a string from the
    array?

    sTemp = FunctionName(vA rray) would result in

    sTemp = "1,4,7"

    Tnanks.

    Matthew Wells
    MWells@NumberCr uncher.com


    Tags: None
    • Rick Rothstein
      #2
      Re: Function to build string from array...

      > I can't remember what it is. The opposite of[color=blue]
      >
      > dim vArray as variant
      >
      > vArray = Array(1,4,7)
      >
      > creates a 3 element array of those values, but what builds a string from[/color]
      the[color=blue]
      > array?
      >
      > sTemp = FunctionName(vA rray) would result in
      >
      > sTemp = "1,4,7"[/color]

      You are looking for the Join function...

      ArrayString = Join(vArray, ",")

      Rick - MVP


        Comment

        Previous template Next
        Working...