+ Reply to Thread
Results 1 to 3 of 3

Get Cell Value from external .xls files

  1. #1
    Registered User
    Join Date
    07-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Get Cell Value from external .xls files

    Hi Guys,

    I have a excel receipt system which has macros that I can just press a button and it saves the finished invoice documents into a folder structure with its corresponding months, years and days..

    Now that I have a year full of monthly folders and days, IE:
    (folder -June15)
    files-
    1000.xls
    1001.xls
    1002.xls
    etc...

    Can any one please help me to write a macro that I can do that checks every folder for xls files from 2015 (july14-june15) and looks at a specific cell to see the total $?.. IE: Cell H15 from every single .xls file, and adds each one together to give me a total sum for the year?

    Any help is immensely appreciated!
    Val

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Get Cell Value from external .xls files

    How, exactly, are the files named?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    07-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Smile Re: Get Cell Value from external .xls files

    Hi xladept,

    The files are names sequentially by the invoice number..

    Example.. there would be a folder for lets say May, in that folder, the files names would be something like:
    1415.xls
    1416.xls
    etc..

    Thank you for helping.
    Val

+ 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. [SOLVED] Need a cell to display the modified date for external files
    By joseph.kelly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2012, 12:03 PM
  2. External files query
    By ahayto in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2012, 10:46 AM
  3. Printing External files
    By livinglegend629 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-22-2010, 04:39 PM
  4. External Files
    By nicole0904 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2006, 10:56 AM
  5. References to external XLS files
    By goto_guy in forum Excel General
    Replies: 1
    Last Post: 01-17-2006, 12:40 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