1
I need to select the information on the left side of the graph according to my need, but I cannot reference the information. I didn’t put any code because I tried it in various ways (according to what I learned from my other questions) and had no success. Follow the link.
http://www.ons.org.br/Paginas/resultados-da-operacao/historico-da-operacao/cmo.aspx
I would like to have at least a reference to how to change the period, for example.
Try to do by this site: https://tableau.ons.org.br/t/ONS_Publico/views/CustoMarginalOperationalCMO/PainelCustoMarginalOperaCMO-MdioSemanal?:embed=y&:showAppBanner=false&:showShareOptions=true&:display_count=no&:showVizHome=no
– danieltakeshi
I tried too. I couldn’t do
– Leandro Lazari
I received the following Error:
Erro inesperado

Ocorreu um erro inesperado. Se você continuar recebendo esse erro, contate o administrador do Tableau Server

ID da sessão372A214630CA4B6BA62EBA8FB96B37FC-0:0

Chamada inesperada para acesso à propriedade ou método. .
The site must have some protection that prevents changing these values.– danieltakeshi
Access the text box with
Set doc = IE.document.getElementbyID("typein_[Parameters].[Parâmetro 5]").getelementsbytagname("span")(0).getelementsbyclassname("QueryBox")(0)
and change the value withdoc.Value = "01/01/2018"
That this error occurs. P.S.: VBA is not one of the best languages for Web.– danieltakeshi
Or you can go clicking and do everything step by step with
doc.Click
– danieltakeshi
At least for now I will no longer work with VBA. Thank you very much for your help and for your time Daniel. I’ve learned a lot from your answers.
– Leandro Lazari