Set word variable to a document that’s already open

Hi there,

Thanks for looking.

I'm using the following variables as part of my larger procedure...

Please Login or Register  to view this content.

...and setting them as follows:

Please Login or Register  to view this content.

I just want to know how I'd set the wrdMyDoc variable if the desired document is already opened as I don't want to re-open it again in an another instance of Word as is the current case.

Note that as the code uses early binding a reference to 'Microsoft Word nn.n Object Library' is required. Also cell C1 contains the directory while cell C2 contains the file name.

Any advice would be greatly appreciated.

Kind regards,

Robert

Try something like this see if it helps:

Please Login or Register  to view this content.

Hi millz,

Thanks for that. Unfortunately it always produces the 'Bad file name' error at this line...

Please Login or Register  to view this content.

...even though the file is definitely open and visible. I do vaguely recall this being a known issue and that the only way around it was to use the document's index number which I'm not sure how to get, would you?

The only other way I can think of is to try and return each name in the Taskbar to check if the file is open but this seems like overkill to me.

Appreciate any further help.

Robert

No, still no go. Did you get it to work on a local machine or from a server (as I'm trying)?

This is what I just tried again. If word is not opened, macro launches it, and open the document Doc1.docx. If Doc1 is already opened, no error occurs.

Edit: I work between Access and Excel a lot, so part of the code is what I actually use to launch Excel from Access, only amended to try to make it work for you. I don't know how differently would it work between a local machine and a server.

Please Login or Register  to view this content.

No, whatever I try it keeps returning the Bad File Name error message. I'll keep digging.

I really appreciate your efforts

Regards,

Robert

Perhaps you can try with GetObject("path of file")

No as that opens the same document in a separate instance of Word - just what I'm trying to avoid.

I've almost solved it with this, I found the work around was to use an object if Word is already open as so (the code is quite long as it copies a named range from Excel into a bookmark of the same name in Word and has error checking built in):

Please Login or Register  to view this content.

The only remaining issue is the cell fill color from Excel isn't be transferred to the Word bookmark. Not sure why.

Thank you both, especially millz

Robert

Hi Izandol,

Yes, that does seem like the case. I think it had opened the same document from another test I was doing (I've been on this for days!!).

Great work Izandol and thanks for posting

Robert