Your question is confusing ...after selecting the first link/ group "Client Documents-PCG" , and extracting the table/details to excel sheet , u want to selcet the second link " Cleint Documents - FCCS" and extract the data into the excel. is this what you want to do?
Also exceute = 1 on row 9 is read what does this mean? while executing row 1 is it going on row 9?
Oh, yes my question is confussing. Thats why i tried to write a story to help myself explain this to myself and everyone here. lol. omgoodness
Well, I figured it out. I rid my script of the r = r + Mr (or Mr = r + Mr) and all works fine
Uma87, yes to your first question. Depending on the tables extracted , 1, 7, 9, etc; I would then need to reuse my extraced file (my issue here) and keep my count Mr straight as I skipm tables 2,3,4,5,6, 8, 10 ... etc.
Row 1...# of table 9.
I am sorry if i do not answer your questions fully.