Results 1 to 15 of 15

Command Button to retireive open workbook names

Threaded View

Robotacha2010 Command Button to retireive... 05-25-2012, 07:17 AM
TMS Re: Command Button to... 05-25-2012, 07:27 AM
Steffen Thomsen Re: Command Button to... 05-25-2012, 07:34 AM
TMS Re: Command Button to... 05-25-2012, 07:38 AM
Steffen Thomsen Re: Command Button to... 05-25-2012, 07:45 AM
Robotacha2010 Re: Command Button to... 05-25-2012, 08:05 AM
Robotacha2010 Re: Command Button to... 05-25-2012, 07:44 AM
Steffen Thomsen Re: Command Button to... 05-25-2012, 07:44 AM
TMS Re: Command Button to... 05-25-2012, 08:00 AM
Robotacha2010 Re: Command Button to... 05-25-2012, 08:04 AM
TMS Re: Command Button to... 05-25-2012, 08:18 AM
Robotacha2010 Re: Command Button to... 05-25-2012, 08:20 AM
Robotacha2010 Re: Command Button to... 05-25-2012, 08:21 AM
Robotacha2010 Re: Command Button to... 05-25-2012, 08:28 AM
TMS Re: Command Button to... 05-25-2012, 08:49 AM
  1. #1
    Forum Contributor
    Join Date
    12-04-2009
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    127

    Command Button to retireive open workbook names

    Not sure if its possible,

    I have a master workbook which logs all potential new business.

    It logs NAME, REP, COMPANY, PHONE, ACCOUNT MANAGER, POSTCODE & COMMENTS.

    It currently does this using INDIRECT functions.

    The information comes via emailed workbooks. I open the emailed workbook, then type the filename into A1 (or whatever row is the next available empty one)

    Then the INDIRECT functions populate the relevant cells. I then PASTE VALUES and save.

    I get about 15 emails aday, and combined, it takes up a fair amount of time.

    so,

    what im thinking is, If I save all the work until the end of the day, then open ALL files I have received,

    Would it be possible to create a macro, assign it to a command button on the master workbook, and when clicked,

    It systematically retrieves the filenames of all open workbooks, and paste them into column A one by one, populating the cells, then copy & paste values?



    How much work would be involved for a macro like this?


    thanks.

    Mike.
    Last edited by Robotacha2010; 05-25-2012 at 08:55 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