Hi all,
i'm attempting to use VBA to have internet explorer open, navigate to a website open the excel workbook copy & paste the sheet into an existing open workbook (essentially replacing all data with most recent data) and close the workbook (the one from which data is coming from) i've gotten to the point where i have the option to open/save/cancel the download but not sure where to go from there. i've also attached the workbook that i want it to go in. basically just copy and paste into "Rate" worksheet overwriting previous data.
any help is appreciated!
Sub APORTable()
Dim oIE As InternetExplorer
Dim oExcel As Excel.Application
Set oIE = CreateObject("InternetExplorer.Application")
oIE.Navigate ("http://www.ffiec.gov/ratespread/YieldTableFixed.CSV")
Do While oIE.Busy: DoEvents: Loop
Do While oIE.readyState <> 4: DoEvents: Loop
oIE.Visible = True
End Sub
Bookmarks