Alternative to Shared Workbook

[LORDMARKS]

Hi all

I have been given a workbook to improve the functionality. The main issue is multi user access, the workbook is shared between about 10 users at any one time, all adding data to the same page.

However due to the nature of the running VBA this workbook can not shared in the normal way. So I am looking for other ways I could set up a workbook, or collection of workbooks to gather the data from mutiple users at the same time?

I was thinking of some kind of workbook that exports and imports the data to subbooks, but I cant get my head around how i would set it up.

If anyone has any ideas for me to look at, or any experiance in this area, please post..Thanks

 

[dmt32]

Hi,
Most here, me included would strongly advise that you avoid sharing a workbook. Article here worth a read:http://blog.contextures.com/archives/2008/11/18/avoiding-shared-workbooks-in-excel/

Your thoughts to have a common workbook (database) & have sub workbooks (templates) for each user is a more practical approach & in past, MS produced a very useful addin to do just this but seem to have discontinued it in later versions. See here for further info:How to Use the Template Wizard with Data Tracking Add-In

In absence of this you can still make the idea work but depends on your VBA skills to update the coding in your workbook.

To understand what your current workbook is doing, it would be helpful to forum if you could place a copy of your workbook in a public dropbox, contributors here should then be able to offer some guidance.

Hope Helpful

Dave