Results 1 to 5 of 5

Macro asking to select the folder and open file.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    272

    Macro asking to select the folder and open file.

    Dear All,

    On monthly basis, I have to update excel file from files prepared on daily basis. ( ie to select 30 different sub-folder and open 30 different files ).

    Kindly let me know the macro which will ask me to select the sub-folder and open the file --> copy the data --> Paste Special the data in monthly file --> Close the file.
    Again ask me to select next sub-folder --> copy the data --> Paste Special the data in monthly file --> Close the file.
    And so on ...... till reached the last sub-folder.

    My email Id : [email protected].

    Thanks in advance.
    Last edited by lalaarif1; 09-03-2013 at 12:51 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to open every file in a folder, run a certain macro and close each file.
    By masben in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-14-2013, 05:45 AM
  2. Macro to open Folder and File
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-06-2013, 06:17 PM
  3. [SOLVED] Open specific folder, select file to open and copy then paste
    By Kranky in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-22-2012, 12:14 AM
  4. Macro to open latest file within a folder
    By Roop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2012, 02:56 PM
  5. Macro to open same named file from different folder
    By mrvindu in forum Excel General
    Replies: 0
    Last Post: 02-25-2011, 03:37 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