+ Reply to Thread
Results 1 to 5 of 5

Solution about Shared Workbook

  1. #1
    Forum Contributor
    Join Date
    05-14-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    155

    Solution about Shared Workbook

    Dear Experts,
    Greetings!
    I am happy to say that being a member of the forum and learn a lot of methods.
    By collecting many codes i am able to do many useful files for my team to reduce usage of time.
    Recently I am working on a project. Below are the key activities: -
    1) There are 4 Projects for which engineering team are working
    2) For Each Project one Master sheet which contains total drawing master for this project.
    3) The respective engineers, they want to send drawings to the respective reviewer.

    For these above activities, I have made Engineer's Wise One DRRF.xlsm file (For All engineers same format, only the file names are changed as per their Emp No.) and stored on a shared folder.
    I have kept the Master list of drawing files (data.xlsx) also in the same folder.
    Now, whenever any engineer wants to send any drawing for review, they are using DRRF.xlsm (For their name) where they are selecting project, entering document numbers and then submitting for review.
    Once they are submitting, the data.xlsx file open and copy the requested document detail from DRRF.xlsm save and close the database.xlsx file. then form the opened file (DRRF.xlsm) it goes to reciepents using outlook and make drrf as pdf as attachment.

    Only the problem is when more than one engineer make review request and the data.xlsx being used by any user, another user is unable to proceed because his data is not copied in data.xlsx file.
    What will be the best way that no any user will stuck. Also note that data.xlsx is saved as shared file.

    Please read above and guide me to make this file error free for users
    Thanks/Regards,
    Last edited by FDibbins; 03-19-2019 at 11:51 PM.
    Rajeev Kumar

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Error Free Program

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.
    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    05-14-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    155

    Solution about Shared Workbook

    Dear Experts,
    Greetings!
    I am happy to say that being a member of the forum and learn a lot of methods.
    By collecting many codes i am able to do many useful files for my team to reduce usage of time.
    Recently I am working on a project. Below are the key activities: -
    1) There are 4 Projects for which engineering team are working
    2) For Each Project one Master sheet which contains total drawing master for this project.
    3) The respective engineers, they want to send drawings to the respective reviewer.

    For these above activities, I have made Engineer's Wise One DRRF.xlsm file (For All engineers same format, only the file names are changed as per their Emp No.) and stored on a shared folder.
    I have kept the Master list of drawing files (data.xlsx) also in the same folder.
    Now, whenever any engineer wants to send any drawing for review, they are using DRRF.xlsm (For their name) where they are selecting project, entering document numbers and then submitting for review.
    Once they are submitting, the data.xlsx file open and copy the requested document detail from DRRF.xlsm save and close the database.xlsx file. then form the opened file (DRRF.xlsm) it goes to reciepents using outlook and make drrf as pdf as attachment.

    Only the problem is when more than one engineer make review request and the data.xlsx being used by any user, another user is unable to proceed because his data is not copied in data.xlsx file.
    What will be the best way that no any user will stuck. Also note that data.xlsx is saved as shared file.

    Please read above and guide me to make this file error free for users
    Thanks/Regards

  4. #4
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Error Free Program

    Bad news
    What you want is not possible in excel 2007.
    Once the file is open, others can only open it as Read only.
    Click the * Add Reputation below to say thanks.

  5. #5
    Forum Contributor
    Join Date
    05-14-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    155

    Re: Error Free Program

    Agreed, Is there any other arrangement in Excel 2013 or any logic that if another user is using it should copied in temporary file and as the other user close that file, data must copied into the data.xlsx from temporary file...
    Just imagine and think about it....

    Thanks

+ 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. does excell have a free "reader" program like powerpoint
    By raymondao in forum Excel General
    Replies: 3
    Last Post: 02-21-2006, 11:00 AM
  2. Free rolodex program
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 03-03-2005, 04:06 PM
  3. Free rolodex program
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2005, 04:06 PM
  4. Replies: 1
    Last Post: 03-02-2005, 11:36 AM
  5. Replies: 0
    Last Post: 03-01-2005, 03:06 PM
  6. Replies: 0
    Last Post: 03-01-2005, 03:06 PM
  7. Replies: 0
    Last Post: 03-01-2005, 03:06 PM
  8. Replies: 0
    Last Post: 03-01-2005, 03:06 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