Results 1 to 10 of 10

Open column of url's as csv files and append as new sheet

Threaded View

  1. #1
    Registered User
    Join Date
    09-03-2012
    Location
    Virginia
    MS-Off Ver
    excel 2010
    Posts
    18

    Open column of url's as csv files and append as new sheet

    Hi. I have a column(E) of urls that download data as a csv file. I need a macro to open the file, copy the data from the csv file and then append to a new worksheet in the current workbook. The worksheet needs to be named from the cell in Column (B). Finally, the data in the worksheet needs to be sorted from oldest to newest.

    A------B-------C-------D-------E
    _____aapl___________________http://ichart.finance.yahoo.com/tabl...=d&ignore=.csv
    _____adbe__________________ http://ichart.finance.yahoo.com/tabl...=d&ignore=.csv


    Thanks for your help.
    Attached Files Attached Files
    Last edited by rgilpatric; 11-04-2012 at 09:13 AM.

Thread Information

Users Browsing this Thread

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

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