Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

Multiple Users Of Vba Userform, All Data Saved To One Database

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hello,

I'm pretty new at VBA and was wondering if you could help me out on this:

I have created a VBA userform but will need to have it used by at least 5 users. My question is, can it be done with all users working at the same time and when saving their work all data entered will go to one master excel sheet? if yes, would you be kind enough to share the code?
MS Access is not an option for me so I was wondering if you could help me do this in excel.

thank you so much and would really appreciate to hear from anyone soon.


Similar Excel Video Tutorials

Helpful Excel Macros

Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when
Prevent Saving a Workbook under a Different File Name
- This Excel macro prevents the user from saving an excel file or workbook under a different file name. The file can only
Combine Multiple Workbooks into One
- This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and workshe
Pop-Up Message Box When a Cell Reaches a Certain Value or Contains Certain Text
- This macro will display a message box in excel when a cell reaches a certain value or contains certain text. This means
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
- This Excel macro allows you to filter a data set on multiple columns and criteria at once. This means that you can filt

Similar Topics







Hello,

I'm pretty new at VBA and was wondering if you could help me out on this:

I have created a VBA userform but will need to have it used by at least 5 users. My question is, can it be done with all users working at the same time and when saving their work all data entered will go to one master excel sheet? if yes, would you be kind enough to share the code?
MS Access is not an option for me so I was wondering if you could help me do this in excel.

thank you so much and would really appreciate to hear from anyone soon.

Hi there,

I don't have access to any kind of database enviroment for the project I am currently working on (long story) so I am investigating the possibility of using Excel as a database. I've been able to do this in the past however my designs have alaways contained work arounds. I wondering if there are any methods people find effective to cope with the following issues...

The program I am building is in Excel/VBA and is accessed by 60+ users ReadOnly from one centrally stored document (referred to as a Client).

Each user can enter data into a simple userform and click a "Submit" button which I want to do the following...

Access a central spreadhseet (my "database") and write a line of data to this. The problem is that if 60+ users are doing this (eventhough the database would only be open for a few seconds by each user) is that this may cause some not to be able to access the "database". Is there any way I can have some sort of multiple user access to this file location?

Andy


Dear Experts,

Is it possible to use the userform when it is protected and shared.
I am able to access when it is protected. but unable to access when that protected worksheet is shared.runtime error message " unprotect method sheet class failed" appears it is shared and used.I have already raised this [b]issue in the forum.I understood from the answers that it is not possible.

" My requirement is multiple users should use the form and they should not have the access to edit the entires made by them"

Please give me a solution.

" Being a moderator myself i should only be able to edit or modify the entries made by the users."

Note:
I dont want to create multiple excel sheets for multiple users.i want to use a single excel sheet (Shared and protected)

Also provide me an alterante solutions if any!!


I need help with data access pages. I created an access database on my PC and it is stored on my PC. I created a DAP that works great on my PC, but I need to share this database with other users in my office. Most of the users work on MACs. I would like to put the DAP onto the network and have the MAC users acces the database through the DAP. They only need viewing capabilities. I am new to Access and I am not sure how to proceed. Is this possible?
:o


Good Evening,
I am wondering if anyone can assist.

I have an excel sheet that has a userform on, when this is open my users are required to cross reference with another excel sheet they have just typed up to make sure they enter the right information into the userform. The only problem i have is, when the userform is open my users cant access any other excel workbooks...

Is there a way round this?

Regards
MArk


Hi guys

I built the application in excel so the frontend and backend is Excel only. My problem is how to allow multiple users toi have access to the excel application at the same time so if they are adding new rows through userform then it should appear in excel spreadsheet. There is a data entry userform and I want to give access to about 5 users so that they can use it simultaneously and the rows gets added simutaneously in the excelsheet.

Any help would be much appreciated.

Thanks


I would like to create a Interface [document] that I can put the button for many userform, which will report to the designated excel wkbks.

Can I set up this document so multiple users can open it at the same time?
Would all users be able to enter data into the each userform?
At no time should there be multiple users using the same userform, but multiple users will be accessing this document[interface] at the same time.
Is there any method that I can create the document, much like a web page, in that there will not be any designated software tool bars etc. on the page. It would only have my design of the page and a list of userforms.


Dear all,

Is there a possibility to work on an excel sheet with different users (on a network) at the same time. I'd like to make an application on which different users can write at the same time. They will only adapt their own colums/cells. I think the standard excel can only handle one users adapting the sheet, the others only have reading rights. Maybe there's a work around or other solutions.

kind regards,
kizzie


Hello Everyone,
This is my first post so please be patient.
I have a question: can I create a workbook using userforms for one user to enter detailed information about projects such as project#, client name, type of project, time spent, initials etc. , while other users update the "project time" by searching "project #" and entering that info on another userform??

I have created a simple userform which just adds the detailed info row by row and where multiple entries for the same "project#" are entered and users need to search for the "project#" and edit the time. There must be a better way. I'm trying to keep it as simple as possibble for the end users updating the "project time".

Any suggestion would truly be apprciated. Cheers.


Hi all,

I have a workbook that I would like multiple users to be able to access at the same time. Since my values are inserted through a form in the workbook I came up with the following solution...

The workbook was set to shared. The data entered is entered through a form. When the user have entered his/her data and clicks the OK button the following happens...
1. The workbook is saved (=all updates from other users are entered)
2. The values in the form are inserted into another sheet of the workbook.
3. The workbook is saved once again so the new values are committed.

This process takes about 15 seconds today, but I think my users are willing to accept this if the workbook isn't locked only to one user. I'm also counting on that the workbook doesn't become too big so that the saving process takes too long. Is this solution ok? Is there a better solution without having to add a real database?


Hi All,

I am currently working on an Excel project which i need to submit asap.
Your kind help will be very much appreciated.

Project:
Users to use Excel as front-end to enter data and click on SUBMIT which exports data to SQL.

Data Source:
I gave the folder path. Eg: s:\Test\test.xls. This is the Excel on shared drive where users access file from, enter data and click submit.

Issue:
When multiple users use the same form at a time, sometimes it picks up the data that they have entered (without saving the file) but sometimes it picks up the data what the previous user had originally saved (data thats saved on the sheet previously).

Solution:
So I am looking for a solution where, instead of giving the file path as datasource, is there a possibility to give ActiveWorkbook (current workbook) as datasource?

Or is there any alternative solution where data from excel need to be exported to SQL2005 and multiple users can use the file at the same time?

Look forward to your suggestions as i need to deliver this asap.

Many Thanks in advance.


Question: Is it possible to use Excel VB to upload data to an Access database residing on a web server (ie http://www.somewhere.com/db.mdb)?

We are working on a project where we need campus users to input information on excel spreadsheets and then we want to upload that data to a central database for analysis. I have the code to upload the data to a database stored on a network drive. The issue is that not all users will have access to the same network drives nor do we want to try and give access to all the possible users. Some users may be accessing the files through the web and not from campus. I know that with excel we could pull/push data from/to other excel files stored in web folders. Can we do the same to an Access database.

Second question: Would Access be the best choice or would an SQL database be better? We would still have the same access issues as above, but is it more efficient?

Thanks in advance for the help,
Joel


Im have setup a spreadsheet that is required to be updated on a daily basis by lots of users that uses a userform to enter data onto the worksheet and the results need to be analysed, various charts created etc. I want to add a link to the userform via a website so that data can be added by anyone by accessing the website. Will this work efficiently with users and can i restrict access/hide/disable etc the worksheet controls so that only the userform appears? I have designed various web GUI using php and mysql and also asp with access etc but i want to know is the excel userform GUI a good enough solution.


I would like to share an excel workbook among multiple users. Basically where 2 people can be working on the same file at the same time. Whats the best way to go about this? I know of the tools---> shared workbook option but i've been hearing that conflicting data is a major problem with that.

Is there any way to have the excel file constantly updating with saved changes from other users currently working in the file? This would decrease the conflicting data quite a bit. Thanks


hello, i am trying to share one workbook with 15 users on the network and every user have there own sheet and one sheet for monitering this sheet is using formulas to captur all 15 sheets data.. now some users wont have the same same network drive... is there a way i could have some kind of add in to connect all the users with internet connection (not network)together bcz all of the users will have internet access.

lets say every1 is working on there sheet and all the updates are going into the monitering sheet..

if possible please advice,, and thanks for reading.


Im trying to build a Database for work but I just don't know where to start!! The concept is pretty simple but making it work seems very difficult-So looking for some guidance please?

Each day in our email we receive 3 different excel files with several hundred rows of accounts that need to be worked. I am looking to merge these files into one DB for multiple users to work from, and mark each row as complete with date, time, name (working the oldest record first). And at the same time create an audit trail as well as a high level completion % report.

I am not sure if something this simple would need a BE & FE split on the colleague network? (2-7 users max.) Also how would I ensure that the multiple users didn't work the same records? ie 7 users logged in and all start at record 1....? And Lastly, should I put all the data into one table? Or 3 separate tables? The Excel files that come through are roughly the same layout. Thanks for any help, i'm on Access 2003 running on XP.


Is there a way of making excel accessible to multiple users at the same time so they can all go into it and input date, save the same file regardless if someone is already using it and not override the other users work. Kind of like an access data base.

I sure the answer is NO and this is what I have advised my employer, but he seem to think it wont be an issue.


Hey,

How do you have a protected AND a shared workbook???

I don't want users changing anytihng in this spreadsheet (apart from via a userform) but I want them to be able to see the data. It *has* to be shared.

Is there anyway to share AND not allow users access to anything other than a userform?

Regards,

James


Hi,

I prepared one dataentry software in excel vba. I have created dataentry form and i want to share that user form to 50 users and they will put the data on a daily basis Simultaneously .

I Need -
I need all users data should be store in single excel sheet all users will work Simultaneously. evry users should not know about database file location. i want to provide a exe file to all users that exe file should be link with Master Excel database file. user will click on exe file and they will get only dataentry form.
How can i prepare the exe file.

It's Very Urgent. Please Hepl me.


Regards,
Krishna


This may be a really simple question, but I would really appreciate some help.

We have a database with tables in SQL2005. Not all users can access this database, and the information I want to show is not easy to find and search within the database.

I have successfully created an Excel sheet which imports this external data and filters it to show what we need to see. The file is set to refresh on opening, and to update every 60 minutes.

It is only for reference, we do not need to enter any data in this file.

Multiple users may be looking at this at any one time.

My problem is that some users get a message that says "Microsoft ODBC Driver MAnager Data Source not found and no default driver specified" so the file does not refresh properly. I have checked that they all have the same access rights, so I think that is not the problem.

Any ideas please? My neat solution to a problem is falling apart about my ears!


Hello All,

I have the following scenario.I have created a excel book for my users to input data in the sheet, then the sheet gets exported to access via VB code. Each user has his personal access database and excel book. If one of my users deletes his excel book and gets a copy from another user, the wrong access database will be updated. So I have done the following.

A21 has the users ID wich gets updated every time the book is opened via Application.UserName

A22 has the users ID.Hard coded.

How to I make the book close if A22 is not equal to A21.

Thanks


ok, here goes. I have a shared workbook that is going to be accessed by another workbook which always opens read only. Users of the R/O workbook will hit a macro button located within it and what then happens is the shared workbook is opened, a specific cell within it will be changed, the shared workbook saved and then closed. However, every user doing this will be saving to a different cell.

All this happens in VBA code very quickly.

The question I have is about how excel saves to a shared workbook.

I know that when it's actually saving, excel locks the shared workbook until the save action is finished. That's a not a problem to deal with, I can just put in code that while .fileislocked = true to wait. However, what I need to know is exactly what is saved when a user opens a shared workbook, changes 1 cell and saves it. Does Excel save the entire workbook or does it just save that cell?

The workbook will be accessed by around 30 people at the same time, saving single cell changes to it around every 2 minutes (each).

I also know that in the shared workbook options I can have an option to either have a dialog box appear when two users try to save to the same cell, or just have the changes being saved overwriting whatever is there. That also shouldn't be an issue as no two users will ever write to the same cell at the same time in the setup I have, it'll always be different cells.

However.....because I'm not keeping the shared workbook open all the time on each users PC I need to know how the save event works. Is it possible that two users could open the shared workbook at the same time, one of them saves data to a cell and a split second later the other one saves to a different cell.....will the second save overwrite the change to the first cell?

The options in shared workbooks kind of imply that it won't.....for example, the option of seeing changes other people have made when you save. But it doesn't state it explicitly, therefore before I implement this way of doing things I'd like to know if it will actually work or if I need to think of something else.

I hope I've made this clear enough, it's causing my poor, tired brain to overheat.


Hi,

I prepared one dataentry software in excel vba. I have created dataentry form and i want to share that user form to 50 users and they will put the data on a daily basis Simultaneously .

I Need -
I need all users data should be store in single excel sheet all users will work Simultaneously. evry users should not know about database file location. i want to provide a exe file to all users that exe file should be link with Master Excel database file. user will click on exe file and they will get only dataentry form.
How can i prepare the exe file.

It's Very Urgent. Please Hepl me.


Regards,
Krishna


Hello all,

i have recently created a database and am in the finalizing stages.
I now need to share the database on our network so as mutiple computers/users can access the database and add/edit records via the forms.
but i dont want them to be able to change the display or design of the database.

what is the best way to share the database?
will all the computers that want to use the database require access 2007?
how can i remove the buttons to prevent users from editing the appearance/data/design?

Thanks,
Josh


hello,

I have an excel database which is populated using a userform (within the same workbook).

It has now come to light that 2 people need to be able to access the userform simultaneously and save information (new calls) together to that common database.

Can you please advise if and how this might be possible?

Cheers
PJ