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.

hi, try the modified but untested version below, does it do what you want?
also, your column layout seems to have changed from your initial post, so I hope I have it the right way around.

Originally Posted by acsishere

I have a code which does the following:

It runs from a separate file. It opens the Fname.XLS and see the file name & it's password, if right, then opens the source file (where the data is avaiable) to copy and then opens the Evaluation1 sheet in the same file to paste.

Please Login or Register  to view this content.

I need the modification in the above code to do the following:

In Fname.Xls, ColA data consist MASFILEs. ColB data consists Passwords. ColC consists REPFILEs (Masfile1 & Repfile1 are having similar password PASSWORD1 and Masfile2 & Repfile2 password is PASSWORD2 and so on...)

The above code copies & pastes the Range within the same workbook. I need to copy Range COPYTOE and then to paste in another workbook (the related REPFILE).

Any help? Please....

Thanks in advance.

acsishere.

hth
Rob

hi,

Neither of the two files that you have attached include any code therefore no-one can see what "adjustments" you have made to my suggested (untested) code, which in turn makes it hard for us to understand what is going wrong...

Can you please reattach the files with the modified code & comments stating what the errrors are & where in the code they occur?

Unfortunately, I don't think I'll get another chance to look at this before work tomorrow (unless you're very quick with the attachment b/c I'm off to bed soon) - hopefully someone else will be able to help.

Rob