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
Yes, it is possible as long as workbook is shared.
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
ExcelUserform.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Dave
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