Hi everyone,

Does everyone knows how to transfer from 1 excel workbook to another excel workbook that has password protected?

Thank...

Have you tried <Ctrl><C> / <Ctrl><V> with File-->Open... ?

Sam

Let say book1 got these fields in sheet 1 and book1 is a password
protected file.

A1 = "Number"
B1 = " Name"
C1 = "Place"
D1 = "Time"


Then book2 got these fields in sheet 1 and this book2 allows every user to go in
to update their data

G5 = "Number"
G6 = "Name"
H1 = "Place"
H7 = "Time"

After they fill up the data and click the button in the sheet1 of book2, it will
automatically update the record in the A1, B1, C1, D1 in the book1 without
opening the book2. Hence, the book1 must prevent duplicate record.

How should i do?

When you say it will update the record, do you really mean it will append (add) a new record? If not, how can there be a duplicate record? I'm confused.

Sam

Hi Sam,

What i meant is that some fields in book1 cannot be the same value or text when adding the record.

I assume you meant "... without opening the book1." If that's the case, within the VBA routine for handling the data transfer to book1, you can also check for duplicates. Or am I missing something?

Sam