+ Reply to Thread
Results 1 to 8 of 8

Excel XLSM Workbook with VBA UserForm unable to Share with Multiple Users on Network

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    AA
    MS-Off Ver
    Word 2010
    Posts
    26

    Excel XLSM Workbook with VBA UserForm unable to Share with Multiple Users on Network

    Hi there

    We created a VBA Excel XLSM with UserForm.

    The issue is unable to Share with Multiple Users on Network. So i have a vba multi user form you can download the attachment, use profile :

    username: Guest
    Password: Guest

    or

    username: Mohamedk
    Password: P@ssword123

    Our aim is to have this workbook on our network drive (central) and users to access this

    Please review and assist or fix vb code

    Regards
    Shabeersa
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    567

    Re: Excel XLSM Workbook with VBA UserForm unable to Share with Multiple Users on Network

    Your workbook is configured for 64bit Excel.....which I currently don't have access to cos I've left my surface pro in the hotel. This means none of your code works for me, so I can't have a proper look and don't have the time or patience to convert to 32bit.....however.....for multi user interfaces in Excel you need to have your UI workbook set as a 'Read Only' file so all users can access it. Everything the UI does is then written to whatever data source / store you're using with checks in the code to ensure read / writes succeed.

    Do not even think about using Excel's 'shared workbook' functions.

  3. #3
    Registered User
    Join Date
    04-22-2013
    Location
    AA
    MS-Off Ver
    Word 2010
    Posts
    26

    Re: Excel XLSM Workbook with VBA UserForm unable to Share with Multiple Users on Network

    @ BellyGas

    Agree using Excel's 'shared workbook' is very very bad. I am having issues

  4. #4
    Registered User
    Join Date
    04-22-2013
    Location
    AA
    MS-Off Ver
    Word 2010
    Posts
    26

    Re: Excel XLSM Workbook with VBA UserForm unable to Share with Multiple Users on Network

    Any other suggestion how to resolve this

  5. #5
    Registered User
    Join Date
    04-22-2013
    Location
    AA
    MS-Off Ver
    Word 2010
    Posts
    26

    Re: Excel XLSM Workbook with VBA UserForm unable to Share with Multiple Users on Network

    Hi BellyGas

    Any work around for my request

  6. #6
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    567

    Re: Excel XLSM Workbook with VBA UserForm unable to Share with Multiple Users on Network

    At the risk of repeating myself:

    "for multi user interfaces in Excel you need to have your UI workbook set as a 'Read Only' file so all users can access it. Everything the UI does is then written to whatever data source / store you're using with checks in the code to ensure read / writes succeed."

  7. #7
    Registered User
    Join Date
    04-22-2013
    Location
    AA
    MS-Off Ver
    Word 2010
    Posts
    26

    Re: Excel XLSM Workbook with VBA UserForm unable to Share with Multiple Users on Network

    could u give me an example of how to do it

  8. #8
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    567

    Re: Excel XLSM Workbook with VBA UserForm unable to Share with Multiple Users on Network

    For example:

    Have a workbook that's saved in a network location that's accessible for all users that are going to use the system. Set that workbook to read only.

    Anything that workbook does isn't saved into itself, instead its saved to whatever data store you've elected to use. Eg, if you're going to use another excel workbook as your data store then the code would first check the file it needs to write to isn't locked (ie another process isn't currently writing to it), if so wait a few seconds and try again. Once confirmed as free for use the code would then open that workbook, write / read whatever it needs to and then close it again.

    Or, if you're going to use a database (Access or otherwise) as your data store then the quickest and easiest way to write to it would be by executing SQL statements on it directly.....therefore, your UI workbook (the read only one) would assemble the SQL statement to be run and send it to the database.

+ 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. Best way to share excel 2013 with multiple users
    By mastelly23 in forum Excel General
    Replies: 1
    Last Post: 06-25-2014, 05:45 PM
  2. Replies: 1
    Last Post: 10-24-2013, 01:24 PM
  3. Replies: 2
    Last Post: 06-20-2012, 07:38 AM
  4. multiple users- Share workbook
    By kizzie in forum Excel General
    Replies: 2
    Last Post: 04-03-2008, 04:03 PM
  5. [SOLVED] What is the max users in excel share workbook?
    By Deb in forum Excel General
    Replies: 1
    Last Post: 03-03-2006, 01:30 PM
  6. How to allow multiple users to update workbook (on network)?
    By quddusaliquddus in forum Excel General
    Replies: 0
    Last Post: 06-29-2005, 02:33 PM
  7. [SOLVED] How can I share a macro with other users in the network within a .
    By Veronica in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-16-2005, 11:06 AM

Tags for this Thread

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