+ Reply to Thread
Results 1 to 15 of 15

Run Excel over several computers

  1. #1
    Registered User
    Join Date
    10-14-2011
    Location
    youngsville, la
    MS-Off Ver
    Excel 2010
    Posts
    10

    Run Excel over several computers

    I have a form that is filled out about 30-50 times a day. But it is filled out by different associates on their own computer. Here is the catch, it needs to generate a new consecutive number on each form, by whoever fills it out next.

    Thus,

    station 1 - 1501
    station 3 - 1502
    station 1 - 1503
    station 2 - 1504

    All of the computers are connected over a server where the file is located. How could i get this to work?

    Thank you for any help.

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Run Excel over several computers

    Hello there,

    Is the form a userform through visual basic or is it just a worksheet formatted as a form?

    Thanks!

  3. #3
    Registered User
    Join Date
    10-14-2011
    Location
    youngsville, la
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Run Excel over several computers

    Right now it is just a form but i will write a userform if i can get this to work.

  4. #4
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Run Excel over several computers

    Could you please provide an example of your workbook?

    Thanks!

  5. #5
    Registered User
    Join Date
    10-14-2011
    Location
    youngsville, la
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Run Excel over several computers

    I am building a userform to populate the rest of the form, i just need J2 to change with an action.
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Run Excel over several computers

    Is this just a form that people use, print and close out of or does it need to be saved somewhere. I'm thinking you could just do a save button and on the click it saves the form where it needs to be saved and then clears the form and adds a PR Number.

  7. #7
    Registered User
    Join Date
    10-14-2011
    Location
    youngsville, la
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Run Excel over several computers

    I will wrote a code that will save the data into another sheet or file or something, that is not a problem. Will using the save format allow for multiple users. Wouldn't it have to actually close for a different user on a different computer to get the next number.

  8. #8
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Run Excel over several computers

    I believe it would have to close in order for another user on another computer to access the file in general.
    So you could create the save button which copies the worksheet and adds it to the end of the workbook or saves the worksheet as a pdf into a designated folder and then at the end of the code just place the code
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    12-20-2011
    Location
    U.S.A.
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Run Excel over several computers

    Do you have access to MS Access? It would be easier to use that to create a simple form that writes to a DB, you could save them on a shared network drive for all the employees to access. This can probably be done in Excel as well, but it'd be like trying to use Excel as a word processor - it can be done, but it's probably easier to just use Word.

  10. #10
    Registered User
    Join Date
    10-14-2011
    Location
    youngsville, la
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Run Excel over several computers

    I'm am not very exerienced in Access. I would have to start from scratch to make that happen.

  11. #11
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Run Excel over several computers

    Still, it would be the better option. Databases are designed for multiple users, Excel is designed for single users, this issue is trivial in access. Might be worth learning it

  12. #12
    Registered User
    Join Date
    10-14-2011
    Location
    youngsville, la
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Run Excel over several computers

    I figured out a way to accomplish it, in case anyone else comes accross this probloem, so many have helped I would like to do the same.

    I coded the file to automatically change the number, as per rvasquez's code above, on open, as well as auto save.

    Also, I saved it as a Shared file.

    I also coded it to auto save and close on fomr execution to make sure a new number is generated on new form.

    Works like a charm.

  13. #13
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Run Excel over several computers

    Glad you got something working. As a word of caution, be careful with shared workbooks; they're a disaster waiting to happen - they don't work particularly well and corruptions can occur frequently.

    So back up your data very often, good luck

  14. #14
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Run Excel over several computers

    @ Forsril

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  15. #15
    Registered User
    Join Date
    10-14-2011
    Location
    youngsville, la
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Run Excel over several computers

    I looked around but could not figure out how to actually mark it as solved. And yes I did star the helpful work above. I definitely want to try to be a productive part of this forum.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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