Hi everyone,
good morning,
My name is Bruno, I'm brazilian. Sorry by the English. I need to build a code of a extraction in the site http://consulta.plus (with login and password, I can pass if you ask), but first I need to fill the number of CPF (individual registration) and find the data of the client I'm look for.
Second, the site presents a table to click in anyone data (image1), I click in the line of the table, and the site goes to the table I want do extract the colum of "Vlr Disponível" and below, "Margem Livre", right below "Margem Livre" (credit card) but I cant to find de right code to find the correct extraction on the table, in a correct column "Vlr. Disponível"
I tried to do this code:
macro = "URL GOTO=http://consulta.plus#!" + vbNewLine
macro = macro + "'Get the values" + vbNewLine
'Verifing the extraction
macro = macro + "TAG POS=1 TYPE=TH ATTR=TXT:Vlr Disponível" + vbNewLine
macro = macro + "TAG POS=R1 TYPE=TD ATTR=CLASS:bdytxt&&TXT:*.* EXTRACT=TXT " + vbNewLine
Summing up, I need a code that extract the colum "Vlr Disponível" and down, "Margem Livre" and "Margem Livre" right below, and make a seach by CPF but when the site find the data of CPF he opens 3 tabs (image2_extract),
Image 2 extract
How can I find this datas and build the code to find the correct colum?
Any doubt contact me, please.
Thank You