This is the tail end of a previous post: http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1361060
I am trying to import some data from my excel spreadsheet into a dynamic array. Then I want to compare that array to another array and spit out what the differences are. Here is the code I have so far: -------------------------------------------- 'Loop thru the Tabs and Navs in the excel sheet and get a total count and gather their names. ''Tab Loop i = 1 'The reason I am using 9 is because that is 'the column that the Tabs start on in excel. ExcelTabCount = datatable.Value(i + 9, 1) Do While ExcelTabCount <> "" i = i +1 ExcelTabCount = datatable.Value(i + 9, 1) Loop numTab = i - 1 ''Nav Loop i = 1 'The reason I am using 17 is because that is 'the column that the Nabs start on in excel. ExcelNavCount = datatable.Value(i + 17, 1) Do While ExcelNavCount <> "" i = i +1 ExcelNavCount = datatable.Value(i + 17, 1) Loop numNav = i - 1 ---------------------------------------------- Now I do know that to get the list of the Tab and Nav names from excel, I just use this: msgbox datatable.Value(i + 9, 1) msgbox datatable.Value(i + 17, 1) within each respected loop. How do I put that text data into an array? I have another array from my previous post that I need to compare it to. Thanks, Steve --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en -~----------~----~----~----~------~----~------~--~---
