+ Reply to Thread
Results 1 to 4 of 4

Copying range into multiple workbooks in a directory

  1. #1
    Forum Contributor
    Join Date
    11-22-2006
    MS-Off Ver
    2010
    Posts
    201

    Copying range into multiple workbooks in a directory

    Hi, hope someone can help me here....

    I have a number of files in separate sub directories on a network drive.
    I have a master file that contains a new section in the range AC10 to BA:20
    I need to open each workbook in the range, go the worksheet "staff", copy this range from the "master" workbook into this worksheet and save, then go to the new workbook in the subdirectory in turn and copy this range as described.
    Where a workbook didnt have a worksheet called "staff" then it would close without doing anything, this should trap any errors caused by the macro opening a workbook that doesnt actually have a "staff worksheet saved.

    If someone can tell me how to do this, all help gratefully received.
    Thanks
    Lucy, London

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    In order to fully automate this process, you must,first of all, have a complete list of the files' names with their respective directory paths ...
    HTH
    Carim


    Top Excel Links

  3. #3
    Forum Contributor
    Join Date
    11-22-2006
    MS-Off Ver
    2010
    Posts
    201
    Thanks Carim, I have that list, do you need me to give them to you in this forum ?

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    To move ahead, why don't you turn on your macro recorder and go through your usual process (with your master workbook and one of your files) in order to visualize the way VBA is going to code your actions ...

    Then will come the time of expanding this one-file routine to all the files you have in your list ...

+ 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