Excel VBA with Internet Explorer (Cont'd) - Getting the row and column no.

Hello,

First of all, thank you to Norie and Sean Thomas who'd helped me with solved my first problem.

After able to find the number of rows, I'm facing with another difficulty.

How do I get the specific row and column value in the table?

I have attached 3 png files where, the 1st shows the "unexpanded" records that were found.
The 2nd attach is the expand of the '1st record' with its items, where the items are actually the header columns with it's values in the intranet.
The 3rd attach is the expand of the item (in the example, is the item no.15)

My question is, how do I go to each record of the given column and take the value?

Given the attach example, how do I write in VBA to give me the value 'Hallett Crescent' from the "recordIndex = 0' (1st record) from item/row 15?

Thank you Sean and Norie for the help.

Norie, to be honest, I have not tried your code yet, reason being, I prefer Sean's code, as it's easier for me to understand (I'm not a programmer) and the idea and logic is similar to what I was trying to do.

That being said, Sean and Norie, I've tried to use Sean's code and modified a little, and it's giving me an error message which is

Run-time error '91':
Object variable or With block variable not set.

Please Login or Register  to view this content.

I tried to look at each String values, and they all give me blank (to be precise "")

Originally Posted by Sean Thomas

What line does it error on?

It errors right on

Please Login or Register  to view this content.

I would assume it'll error on other string as well

Sean,

Thank you for your help!

Interestingly enough, I still receive the same error message, and it's still on the 1st string.

Please Login or Register  to view this content.

WITH THE EXCEPTION that, my string values are now have values, instead of "" (empty).

Originally Posted by Norie

What are you actually trying to do?

By the way, what is it you don't understand in the code I posted?

I thought it was quite straightforward - get table, get data from table by looping through the rows and columns (cells) of the table.

Apologies Norie for not able to understand your code, even though it's a very straightforward one.

What I tried to do is

1. Put the ID from Excel to IE.
2. If found, check how many records
3. If no record found, move to the next input excel value and copy it to IE (back to step 1)
4. If only 1 record found, then, go to excel and input the value from IE from header/item no 45 for example.
5. If multiple records found, then check if value from header/item no 7 is "Disconnect" and header/item no 8 is "Completed".
5.1 If it's true, then do copy and paste the values from other string variables that have been created and put it to excel
5.2 if it's false, then do something else.

I hope this could clarify your questions norie =)

Norie,

Tried to use your code there, but why is it that when I tried to hold on part of the code, i.e. putting a msgbox after the End Select to let me know what's the value for i.e. strCircuit, it's not showing me anything?

It's ok...I found the "error"...it's because you have the "Exit Sub" instead of "Exit For".

Thank you once again guys for your help.

Reps up to both of you! Please check! =D

Originally Posted by Norie

dluhut

I edited and changed the Exit Sub to Exit For.

Yes, I noticed that too.

Also, I think it's supposed to be

Please Login or Register  to view this content.

Originally Posted by Norie

Yep, that's right.

Need to start checking my code I suppose.

Well, at least it's working now!

Thanks to you and Sean =D