+ Reply to Thread
Results 1 to 3 of 3

Pro Tips Or Advise Needed Concerning A Code A Found On YouTube - Multiple Users Editing

  1. #1
    Registered User
    Join Date
    09-23-2019
    Location
    Ghana
    MS-Off Ver
    2016 32 bit and 64 bit
    Posts
    92

    Pro Tips Or Advise Needed Concerning A Code A Found On YouTube - Multiple Users Editing

    Cross posted at:
    https://www.mrexcel.com/board/member...y-mort.401365/
    The reason is that it has been up there for a few days now and I can't get solution for it.

    The variables
    Please Login or Register  to view this content.
    This part of the code sync to the database:
    Please Login or Register  to view this content.
    This part of the code sync from the database:
    Please Login or Register  to view this content.
    I still need help with this please

    So I tried to run a few tests and what I saw was that when I added new sheets to the custData workbook and sync the data to the database, all the sheets are deleted and a new sheet named CustDb is created.

    Is there a way I can, maybe delete only the CustDb sheet, update it with the new data and leave the other sheets undeleted?

    Thanks for helping me out.

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Pro Tips Or Advise Needed Concerning A Code A Found On YouTube - Multiple Users Editin

    i didn't read all of your code. but this:
    Quote Originally Posted by Kelly mort View Post

    Is there a way I can, maybe delete only the CustDb sheet, update it with the new data and leave the other sheets undeleted?
    .
    does have an answer. select the custDB sheet, delete it and then do whatever you want with your data. your quote really doesn't make sense. it sounds like you want to update something, some sheet. then you wanna del the custDB sheet. and not del all the rest of the sheets. don't know about some of your other talk, but del'ing a sheet is easy:
    Please Login or Register  to view this content.
    don't forget to turn off the alerts before.

  3. #3
    Registered User
    Join Date
    09-23-2019
    Location
    Ghana
    MS-Off Ver
    2016 32 bit and 64 bit
    Posts
    92

    Re: Pro Tips Or Advise Needed Concerning A Code A Found On YouTube - Multiple Users Editin

    Thanks for the help.
    I wish all my requests could be addressed.

    The current code is aimed at dealing with a single sheet from the database and a specific sheet from the user's workbook.

    And now, I want a way to handle multiple sheets from the database and also target multiple sheets from the user's workbook.
    Last edited by AliGW; 12-11-2020 at 06:06 AM. Reason: PLEASE don't quote unnecessarily!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multiple Users Editing File Concurrently
    By ormsbyd9 in forum Excel General
    Replies: 7
    Last Post: 08-06-2020, 12:52 AM
  2. Tips to elliminate data entry errors from multiple users
    By Sjordan1307 in forum Excel General
    Replies: 1
    Last Post: 09-19-2019, 12:36 PM
  3. Replies: 2
    Last Post: 10-22-2016, 05:04 PM
  4. Multiple Users editing workbook at same time
    By amymsellers in forum Excel General
    Replies: 2
    Last Post: 06-07-2016, 08:39 AM
  5. [SOLVED] Password code designed for 5 Users - NAVIGATION Help Needed! - CODE Issue!
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-09-2014, 10:46 AM
  6. Replies: 5
    Last Post: 05-22-2012, 04:14 PM
  7. Found Code to List All Folders and Size in Certain Directory. Need Help Editing.
    By jcranst in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2012, 03:11 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1