Results 1 to 12 of 12

Copy a range and paste into another workbook - files are password protected.

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    582

    Copy a range and paste into another workbook - files are password protected.

    Dear Friends,

    I need to copy and paste a range from one workbook to another workbook automatically.

    Basically, I have 180 files in a folder. The details are:
    1) 90 master files
    2) from these a range named "COPYTOE" has to be copied and pasted into another 90 report files.
    3) I have list of files & its passwords in a separate file named FNAME.XLS. In this, Sheet1, A1:C the details consist like this:
    MSFILE1.XLS / REPFILE1.XLS / PASSWORD1
    MSFILE2.XLS / REPFILE2.XLS / PASSWORD2
    MSFILE3.XLS / REPFILE3.XLS / PASSWORD3 ... till 90 files
    (the No.of files may go up if needed)
    (Passwords for both first files of Master & Report file are same)

    4) Now, I need a macro, which run from a separate file, to do the following:
    The macro should first open FNAME.XLS and then to check the filename in ColA1 and password in CellC1 and, if right, then open the first master file to copy COPYTOE range and then check CellB1 for filename & Password for CellC1, if right, then to paste from A4 in Report File.

    For Example:
    Data already entered in MSFILE1.XLS. It's password is "Password1". Now, I am to copy the range COPYTOE from this file and the same should be pasted into REPFILE1.XLS (It's password also the same).

    This should be looped till the last filename exist in sheet1 of Fname.xls.

    As always, I hope someone will help me to solve this problem.

    Thanks in advance.

    acsishere.
    Last edited by VBA Noob; 07-17-2008 at 08:16 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