Getting Data From Java Based Webpage

simplemnt

New Member
Joined
Nov 13, 2017
Messages
2
Hello, I want to ask question about how I can get data from a javascript based webpage with vba code. I want to enter one input data (text) to a textbox and then click on button and finally get the results. I can get data from a normal HTML webpage but in java based webpages i cannot . The html code of the web page is at the pictures.

In code-1 picture, there are side menu links. In this java webpage, when i click the “Telefon No Sorgulama” link, the adress bar does not change, just a new tab is activated within the web page. My first challenge is to open related tab with macro. When I click the link, in the code screen a code has been created starts with “iframe” (code-2 picture). I want to enter “İZMİR” to “ba” textbox, then click on submit button and get the data shown in tbody id=”kayitlar”.

The adres of web page is https://vatandas.uyap.gov.tr/vatandas/index.jsp. But the codes in the pictures are related after login.

I kindly request you to help me with coding. Thanks.




PICTURE CODE-1
https://i.hizliresim.com/lbNl6p.png


PICTURE CODE-2
https://i.hizliresim.com/yzpQO0.png
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,223,897
Messages
6,175,270
Members
452,628
Latest member
dd2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top