Clicking and Download file into a excel (javascript Excel)

[luizandre1976]

I everybody, I´m a begginer user, and I need to download one file from a websie below, I´ve checked a lot of foruns to do that without success. I think that this is a java script, but I didnt find a name of the tag to do this download and I cant find how can I click in some links in this website.


I need a macro in excel that click in "Séries Autorizadas" and then "Lista Completa de Séries Autorizadas" to start the download to a my file folder.

Could you help me please?


This is the website.
Opções

 

[Rijnsent]

Hi Luizandre,
this thread seems to deal with a similar problem: http://www.mrexcel.com/forum/excel-...tomation-using-visual-basic-applications.html
Basically, you're looking at an ASP website and it's hard to pull the data in an easy way, but the code seems to help.
Cheers,
Koen

 

[luizandre1976]

Thank you for your atention!
But did'nt work and I dont know why. I used the same code below:

[COLOR=#333333]Sub Update()[/COLOR]'Add YOUR website
'to Internet Explorer
'trusted website

'Open IE-Internet Options-Security-Trusted Sites-Sites
'then YOUR site

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
With IE
IE.Visible = True

'To open the website
.navigate "http://www.bmfbovespa.com.br/pt_br/servicos/market-data/consultas/mercado-a-vista/opcoes/"
Do While .Busy: DoEvents: Loop
Do While .readyState <> 4: DoEvents: Loop

'To download the file
IE.navigate "javascript:__doPostBack('ctl00$contentPlaceHolderConteudo$seriesAutorizadasEmp$lblListaArquivoSerieAut','')"
Do While .Busy: DoEvents: Loop
End With
 [COLOR=#333333]End Sub
[/COLOR]

What I made wrong?

thanks again

 

[luizandre1976]

I think that the problem is in "busy" code line instructions. I took off some "Busy and loop" lines and it works.
The problem now is with the instructions to save the file.
I´m still working with that.