hello folks,
for some strange reason when I use the Word.Application code from MS Access to open word and then try to create a new document by using the Document.Add method it works only every other time. The first time it works but the 2nd time it doesn't. Then I try again and it works then I try again and it doesn't. Each time it doesn't work it gives the following error message: "Run-time error '462': The remote server machine does not exist or is unavailable."

Does anyone know how to make the remote server machine available so I can make this work properly every time? If I can't get this to work properly then I'll have to display an error message that tells the user there was a problem opening word and to please try again. That won't make the users very happy at all.

thanks in advance,
donrafeal

I was wrong in how I explained it earlier. The first time I try it, it works then every time after that it doesn't work. The only way I can get it to work again is to shut down my application then reopen it and it works after that but only one time. So I can get it to work only once for each time I open it. Here is my code:


Dim AutText As AutoTextEntry
Dim oApp As Object

Set oApp = CreateObject("Word.Application")
oApp.Visible = True
oApp.Documents.Add [u]'This is where the error is thrown.</u>
DoEvents


I'm doing this from MS Access, not MS Word.


thanks,
Donrafeal

I have a similar problem that occurs intermittently while trying to communicate between Access and Word. And, yes it does annoy my users, so if anyone can help I would be grateful. Am using Office XP

William Bradbeer

Hi Donrafeal

Does you loop the program quit/close the application at some time (I am not sure why it is working for first time)

Can you try early binding and check if the app is working


http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)