Hi Excel Gurus
Basically i have a requirement to download file from intranet site which takes me to a webpage where I have to select which month-year FX conversion file I need to download from drop down , Once I select the time (e.g May_2016) and click on download (button) , it gives option to open, Save or save as
The contents of the downloaded excel file is FX rates, I need to select all rate, copy and then paste into my worksheet every time. Now I want to automate this whole process.
I have create Active X Button with below code:
Sub Testing()
Dim URL As String
URL = "http://www.intranet.company.com/exchangerates/?FuseAction=MidMonXLS"
Dim IE As Object
Set IE = CreateObject("internetexplorer.application")
IE.Visible = True
IE.Navigate URL
Call Macro1
End Sub
This will open the internet explorer and take me to URL where I can select and download FX rate, then I recorded the macro1 , which click on the above mentioned ActiveX control and download the file, copy the contents of the downloaded sheet and paste at specific location in my current sheet.
When I click on the ActiveX button, its opening the intranet site, downloading the file, selecting the contents of the downloaded sheet, but then it stops at selecting specific worksheet in my current file...any help how to resolve it?
Basically i have a requirement to download file from intranet site which takes me to a webpage where I have to select which month-year FX conversion file I need to download from drop down , Once I select the time (e.g May_2016) and click on download (button) , it gives option to open, Save or save as
The contents of the downloaded excel file is FX rates, I need to select all rate, copy and then paste into my worksheet every time. Now I want to automate this whole process.
I have create Active X Button with below code:
Sub Testing()
Dim URL As String
URL = "http://www.intranet.company.com/exchangerates/?FuseAction=MidMonXLS"
Dim IE As Object
Set IE = CreateObject("internetexplorer.application")
IE.Visible = True
IE.Navigate URL
Call Macro1
End Sub
This will open the internet explorer and take me to URL where I can select and download FX rate, then I recorded the macro1 , which click on the above mentioned ActiveX control and download the file, copy the contents of the downloaded sheet and paste at specific location in my current sheet.
When I click on the ActiveX button, its opening the intranet site, downloading the file, selecting the contents of the downloaded sheet, but then it stops at selecting specific worksheet in my current file...any help how to resolve it?
