+ Reply to Thread
Results 1 to 2 of 2

Finding external Excel files and crating a dashboard.

  1. #1
    Registered User
    Join Date
    05-26-2006
    Posts
    8

    Finding external Excel files and crating a dashboard.

    Problem:

    I have a folder where Excel files(.xls) are frequently being added and updated. I need to build a "dashboard" type Excel file that can:

    1) look in this folder
    2) find any Excel files
    3) take a totals row from these files
    4) add the totals rows in a single row on the Excel file I am creating.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,911

    Response

    It would be worth recording this sequence to get m ost of the necessary code. Then you can amend this with a section which uses the DIR(Path*.xls) statement to get the list of files. Then just loop the macro around.
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

+ Reply to Thread

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