+ Reply to Thread
Results 1 to 6 of 6

Get data from Excel files from url address list

  1. #1
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Get data from Excel files from url address list

    In an Excel spreadsheet I have a list of other Excel files thus:

    e:\data\file01.xls
    d:\workspace\invoices\invoice01.xls
    c:\sales\inventory\list03\take100.xls

    and so on. New addresses are added daily. The data wanted from the files is always in named ranges.

    How do I go to the files by reading down the list and get the data?

    Any help appreciated

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Get data from Excel files from url address list

    If you want to use that list of files, see if you can modify this to suite...

    =HYPERLINK(A1) assuming that A1 =e:\data\file01.xls
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Re: Get data from Excel files from url address list

    Thanks for that. Can I set up a macro or formula (=indirect?) which reads the new file name and then it needs to read in the edata? I am not sure how to progress to the next step

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Get data from Excel files from url address list

    INDIRECT() only works on open files, your question was that you wanted to go to the file.

    If you want to pull data from a closed file, take a look at the Morefunc add-in, it makes it possibe to use INDIRECT() from closed files.

    Aslo, I suggest you include which version you are using, as members tailor suggestions based on your version

  5. #5
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Re: Get data from Excel files from url address list

    I am running Excel 21013. I cannot use any addin due to corporate security settings.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Get data from Excel files from url address list

    And I have been told MF doesnt play nice with 2013, either

    Aslo, I suggest you include which version you are using, as members tailor suggestions based on your version
    I left out...please update your profile accordingly, sorry

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Forwarding excel files to an email address
    By Khanzaki in forum Excel General
    Replies: 6
    Last Post: 12-28-2012, 06:19 AM
  2. Replies: 1
    Last Post: 01-31-2012, 09:07 PM
  3. Replies: 4
    Last Post: 03-15-2007, 06:53 PM
  4. Replies: 1
    Last Post: 04-15-2005, 07:07 PM
  5. Replies: 2
    Last Post: 03-03-2005, 09:06 PM

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