+ Reply to Thread
Results 1 to 3 of 3

Copy from workbooks from folder

  1. #1
    Forum Contributor
    Join Date
    05-10-2016
    Location
    EUROPE
    MS-Off Ver
    Excel 365 64 bitt
    Posts
    178

    Copy from workbooks from folder

    Hi,

    I found a VBA code on internet that copies data from workbooks in folder.
    I would like to modify the code so it removes the password from the sheet "SUMM" which is "afa" and then copies values to new sheet and after all values from workbooks are copied protect the sheet "SUMM" with the same password.
    I would like to copy values only from the sheet "SUMM" from workbooks.

    Internet page that I found: https://www.get-digital-help.com/cop...nd-subfolders/

    The code I used:
    Please Login or Register  to view this content.
    Thanks for the help I can get on this.
    B.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: Copy from workbooks from folder

    Not very detailed information, it is not known what it should look like.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-10-2016
    Location
    EUROPE
    MS-Off Ver
    Excel 365 64 bitt
    Posts
    178

    Re: Copy from workbooks from folder

    Hi,

    Thanks for the help and sorry for non detailed information. It is working well.
    Is it possible to change the code so it copies from the second row and below?

    Many thanks on this.
    B

+ 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] Macro to copy workbooks to another folder
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2021, 11:42 AM
  2. [SOLVED] macro to copy workbooks from Folder into the appropriate sub-folder
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2021, 02:24 AM
  3. [SOLVED] Copy Range from multiple Workbooks in folder, to Summary Workbook also in same folder?
    By xlyfe in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-24-2018, 01:22 PM
  4. create a compressed folder or zipped folder then copy workbooks to it.
    By Ironman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2012, 03:56 PM
  5. copy all workbooks in a folder to a different workbook
    By prajesh in forum Excel General
    Replies: 6
    Last Post: 11-22-2011, 01:35 AM
  6. copy first sheet from all workbooks in folder
    By Steel Monkey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2011, 02:59 PM
  7. Copy worksheet to all workbooks in specified folder
    By nosstech in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2009, 03:45 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