Results 1 to 6 of 6
  1. #1
    Join Date
    May 2007
    Posts
    92

    Unanswered: transfer data from 1 excel workbook to another excel workbook

    Hi everyone,

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

    Thank...

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Have you tried <Ctrl><C> / <Ctrl><V> with File-->Open... ?

    Sam

  3. #3
    Join Date
    May 2007
    Posts
    92

    ExCel

    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?

  4. #4
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    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

  5. #5
    Join Date
    May 2007
    Posts
    92

    Excel

    Hi Sam,

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

  6. #6
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    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.
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •