Multiuser problem

[LisaPatch]

Hi there

The following code works fine for one user who press the button first and for second user it gives message "Read only document" locked for editing. Can anyone please change the code so that for each user it will open a copy of the word document and not the original one to avoid conflict.

Please Login or Register  to view this content.

Thanks

[royUK]

Excel is not a good choice for multi users

[Kyle123]

Whilst Roy is right, there are better options for a multi-user environment, Excel can work quite well and can sometimes be the only choice - been there :S

I would say that you need to make the word document a template, each time it is then opened it will create a new document, I haven't tested this in your example, but I've done something similar successfully in the past

[LisaPatch]

Hi roy

I am writing the code so that each user will work on a copy oc excel spreadsheet so thats not a problem I am facing as I have used the following code. If you see code in my first post then it prints off the word document perfectly but for multiple users it opens the same document so for one it works but for others its locked. Can if write something like below code to craete a copy of the word document evrytime and print it off so each user will work independently.

Please Login or Register  to view this content.

Thanks

[Kyle123]

Hi Lisa, did you try my suggestion?

[LisaPatch]

Hi kyle123

Don't know exactly what I have to do. Can you make changes in the code to make it working as desired

Thanks

[Kyle123]

No, not really. You need to save the word document "C:\Letter.doc" as a template, not a word document

The line to open the template would then be something like:

Please Login or Register  to view this content.

[LisaPatch]

Hi kyle123

I have all the word documents in Master folder so how can I save them as Word template.

What steps do I need to follow?

Thanks

[LisaPatch]

Hi Kyle

Yes I saved the word document as document template so now in the code do I need to specify the path of the template or the word doument.

Thanks a lot.

[Kyle123]

Open the document

File > Save As > Save as type: "Document Template (*.dot)"

[snb]

You'd better not use reserved words in VBA/Excel/Word to name your macros, functions, names, named ranges.
This is all you need.

Please Login or Register  to view this content.

[LisaPatch]

Hi snb

The code you sent me works at my end but I have not tested whether it works for multiple users or not.

Can you tell me what is difference in that code that will make it working for multiple users please?

Thanks a lot.

[snb]

You can even reduce the code to:

Please Login or Register  to view this content.

[LisaPatch]

snb, can you please tell me how can we print two copies of each document.

Thanks a lot

[Kyle123]

Like this:

Please Login or Register  to view this content.

[snb]

@Kyle

I don't think so....

Please Login or Register  to view this content.

[Kyle123]

@snb fair enough, serves me right for not testing it

Scrap my last post

[LisaPatch]

Hi guys

Sorry I am back again. I am writing the following code that will extract data from Access table and merge that in word document.But sometimes it gives the "Microsoft Excel waiting for another application to perform OLE action" error message.
Can anyone please figure out why the error is coming?

Please Login or Register  to view this content.

Thanks