Results 1 to 9 of 9

Download Excel Workbook from IE copy and paste into existing Workbook

Threaded View

  1. #1
    Registered User
    Join Date
    02-01-2011
    Location
    Philadelphia, Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    57

    Download Excel Workbook from IE copy and paste into existing Workbook

    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
    Attached Files Attached Files
    Last edited by kboy1289; 12-16-2013 at 01:52 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy column based on partial word match in first row and paste into existing workbook
    By David Harris 1987 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 03:52 PM
  2. Copy column based on partial word match in first row and paste into existing workbook
    By David Harris 1987 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 01:02 PM
  3. how to copy excel sheet from one workbook and paste into another workbook, save it ?
    By dearnemo385 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2012, 08:27 AM
  4. Excel: match, vlookup in other workbook, copy and paste in old workbook.
    By BeefGir in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2012, 01:26 PM
  5. Replies: 1
    Last Post: 10-17-2005, 04:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1