Link to home
Start Free TrialLog in
Avatar of surah79
surah79

asked on

Excel userform

Hi Just want to know is it possible to make Excel userform can be used by multiple user at a time as I using it to generate word templates from it
Avatar of dlmille
dlmille
Flag of United States of America image

Please clarify a bit more.  Do you mean multiple people would use the same Excel workbook from a shared drive where the userform is embedded in that workbook?  Certainly, you can do that - they aren't really using the exact same workbook or form at the same time, however - just sharing an exact copy of the workbook containing the userform.  If their output is a unique template that each user is generating, then the answer is YES, according to the parameters I just described.

Alternatively, if you have some type of screensharing program where multiple people can see the same application at the same time, this would be possible.

So - please be a bit more descriptive and I'm sure an E-E expert can help, as they better understand what you're trying to accomplish.

Dave
Avatar of hitsdoshi1
hitsdoshi1

Yes, it is possible as long as workbook is shared.
Avatar of surah79

ASKER

Hi guys I had a uploaded a worksheet with the userform , it merge the data in to a word document also it save the data in the excel sheet, now If i want to make it a multiple user , so that a multiple user can fill the form at the sametime and the data can also be save in the excel sheet. I tried it by using as a shared worksheet but it doesn't succeed
ExcelUserform.xls
ASKER CERTIFIED SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of surah79

ASKER

Well thanks for this, I was thinking for the access . Then I thought if it can be done in Excel it will be good
Its certainly possible - create a connection string to a defined database in Excel (a closed workbook) but you'd need to manage it all, as I believe Access has more built into it to manage multiple users but can't say with confidence.  It should be much easier to work with Access, as you'd still need to use ADO (or other related implementation) in VBA to code retrievals,adds, deletions/modifications.  Stepping out from that, you might google some solutions that don't but they'll have their own overhead to manage the same actions.

Dave