Thread: For Loop
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excel User[_2_] Excel User[_2_] is offline
external usenet poster
 
Posts: 25
Default For Loop

Hi,

I'm hoping someone can help, I have an output from a file:

{"forename":["Forname1","forname2"],"surname":["Surname2","surname2"],"dateOfBirth":["04\/07\/1970","05
\/27\/2009"]}

I would like to convert this into a loop

array1 = "forename1", "surname1", "04\/07\/1970"
array2 = "forename2", "surname2", "05 \/27\/2009"
etc

for each x
'do something
next

I don't mind skipping creating the arrays but don't know who to do this?

Thanks