RDBmerge script and shared workbook

Hi All,

Please see the below script I'm using, it works as a single user workbook however it fails when it's converted to a shared workbook.

The macro when run, copies all of the required data from the array of sheets and collates them into a new sheet called RDBmerge, when I re-run the macro it will re-collate the data to ensure the latest information is in the RDBmerge sheet.

When I covert this to a shared workbook it gives me a runtime error and produces an empty sheet called 'Sheet1'.

The error states:

Run-time error '1004':

That sheet name is already in use. Enter a sheet name that is not in use by another sheet.

Does anyone know why this is happening and what I need to do to stop it?

Module:

Please Login or Register  to view this content.

Functions Module:

Please Login or Register  to view this content.

Thanks

Matt

VBA in shared workbooks as far as I can tell isn't very well supported, its not to say VBA won't run in a shared workbook but its very prone to failure as the entire dynamic of the workbook has changed including various properties.

if you HAVE to use a shared workbook avoid vba.

Use

Please Login or Register  to view this content.

to temporarily "unshare" workbook - run your macro then save file as shared again

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you Nigelog. This has worked perfectly!

No problem
can you mark thread as solved.