Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Suggestion.. (2000 r s1)

    Assuming i have a wbook_master and other various wbooks. The variuos wbook it can opened from many users. The wbook and varuios wbook have a column H with a unique valus as index.
    I would want to update the the wbook_master from the value iserted from user from various wbook in this mode and if i am right tell me (suggestion of Hans is for me a "Sentence"):

    Export the value into MDB from wbook_master.
    When a user insert a new value into column H update the same MDB.
    After with a mcro i import from MBD into wbook_master the new value...
    Is a good idea?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Suggestion.. (2000 r s1)

    That should work better than directly trying to update the master workbook. You already have a lot of code that can be used, from your questions in this and other forums in the beginning of this year and the end of last year.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Suggestion.. (2000 r s1)

    tks Hans, i know the code to update MDB via Excel, and i have used in other projects, but i would want to know your note on my idea...

Posting Permissions

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