Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: code to work out from 2 workbooks
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular gallen's Avatar
    Join Date
    Jun 2011
    Location
    Manchester UK
    Posts
    1,892
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    1 Thread(s)

    Default Re: code to work out from 2 workbooks

    Strange, it worked for me. Do you get any errors? Delete this line:

    Code:
    wb.close
    this will keep the workbook that was closed open. It will let you check 1) if it opens at all 2) It sends the changes over

    - forum use guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


  2. #12
    Board Regular
    Join Date
    Feb 2018
    Location
    Midlands, UK
    Posts
    894
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: code to work out from 2 workbooks

    Hi i removed the wb.close it now works great thanks.
    Is there anyway to stop the closed book opening?
    Last edited by Patriot2879; Aug 22nd, 2019 at 09:40 AM.

  3. #13
    Board Regular gallen's Avatar
    Join Date
    Jun 2011
    Location
    Manchester UK
    Posts
    1,892
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    1 Thread(s)

    Default Re: code to work out from 2 workbooks

    No. You can't write to it without it opening.

    You can hide it but that causes issues.

    It's strange however that not closing it has fixed it which means that the save didn't work. Like I said it works for me

    - forum use guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


  4. #14
    Board Regular
    Join Date
    Feb 2018
    Location
    Midlands, UK
    Posts
    894
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: code to work out from 2 workbooks

    i got it to work now thank you, for some reason the save bit didnt work so i added some code at the bottom to save the range selected this has worked

    thanks for your help, can i also share the sheet and have more than one person have it open? will it still update?

  5. #15
    Board Regular gallen's Avatar
    Join Date
    Jun 2011
    Location
    Manchester UK
    Posts
    1,892
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    1 Thread(s)

    Default Re: code to work out from 2 workbooks

    If the workbook being auto updated is being closed every time then yes it COULD work but the open workbook with more than one user can only have one that is allowed to edit (and save).

    - forum use guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


  6. #16
    Board Regular
    Join Date
    Feb 2018
    Location
    Midlands, UK
    Posts
    894
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: code to work out from 2 workbooks

    ok thank you and thanks again for your help.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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