Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Help seperate Arrays

I'm certain this is not very difficult, but for some reason I am
having difficulty accomplishing what I want.
iobj_dom could contain values like AB, AC, AD2, AF etc. When I write
it I want the values seperated by commas as shown, but what I get is
ABACAD2AF. There could be 1 to ??? elements in the array.

For Each iobj_node In iobj_dom.documentElement.childNodes
ReDim sys(iSys)
sys(iSys) = iobj_node.childNodes(0).Text
iSys = iSys + 1
Next
Range("C" + CStr(ll_range)).Value =
iobj_dom.documentElement.Text

Thanks in advance,
Gabe

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Help seperate Arrays

Accomplished what I wanted using the following code. If anyone has a
better way to do this please let me know.

Thanks,
Gabe

If iobj_dom.documentElement.childNodes.Length 1 Then
For Each iobj_node In iobj_dom.documentElement.childNodes
ReDim sys(iSys)
sys(iSys) = iobj_node.childNodes(0).Text
Range("D" + CStr(ll_range)).Value = (Range("D" +
CStr(ll_range)).Value + sys(CLng(iSys)) + ", ")
iSys = iSys + 1
Next
strLength = Len(Range("D" + CStr(ll_range)).Value)
Range("D" + CStr(ll_range)).Value = Left(Range("D" +
CStr(ll_range)).Value, (strLength - 2))
ElseIf iobj_dom.documentElement.childNodes.Length = 1 Then
Range("D" + CStr(ll_range)).Value =
iobj_dom.documentElement.Text
End If


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add two cells from seperate work sheets into a cell on seperate wo lar Excel Worksheet Functions 6 April 27th 10 06:54 PM
How do I have seperate headers for seperate pages in 1 worksheet? JessicaDL Excel Discussion (Misc queries) 1 February 22nd 08 07:14 PM
How do I seperate a full name field out into three seperate columns? Rod Excel Worksheet Functions 3 October 31st 06 08:06 PM
seperate first 2 lines of column in seperate columns in same row Glynnhamer Excel Discussion (Misc queries) 2 October 9th 06 04:23 AM
How do I seperate data from a pivot into seperate worksheets? Shannon Excel Discussion (Misc queries) 5 August 25th 05 06:07 AM


All times are GMT +1. The time now is 06:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"