Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Import data from Website with a date and options Picker

0

Hello, I have the same challenge for two websites, wich I want to import automaticly the data to excel. First is:

http://www.b3.com.br/pt_br/market-data-e-indices/servicos-de-dados/market-data/consultas/mercado-de-derivativos/contratos-em-aberto/por-tipo-de-participante/

Second is:

https://ptax.bcb.gov.br/ptax_internet/consultaBoletim.do?method=consultarBoletim

Both I have to enter some "configurarion" before I get the table. Date is one of them, but I have other options and I need to press a buttom to have the data I want to integrate to uptadate in an excel table.

Can you help me to understand how can I do that? The simple table integration I can do already, but with these options on the site and a standar URL (don´t change according with the input data) I can´t.

Thank you very much.

Answer
Discuss

Discussion

You have found the question which is half the answer. The other half you may find by doing some research. You will find code to instruct your program to do what you want it to do (which you already know). If, after your research, you have difficulty implementing the code you found, post your code and tell us about the problem it poses or causes.
Variatus (rep: 4889) Sep 27, '19 at 6:22 am
Add to Discussion

Answers

0

I think that this tutorial should get you on your way:

Login to a Website using a Macro

That shows you a way to submit forms using vba and macros in Excel.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login