Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remote Machine not available
Sometimes the code below encounters a runtime error (462) at the line
"Word.Application.Visible." That error says: "The remote server machine does not exist or is not available. What might cause this error? Alan Function StartWord() As Boolean StartWord = False ' Try to open an existing instance of Word On Error Resume Next Set Word = GetObject(, "Word.Application") On Error GoTo 0 ' If Word is not started, start a new instance If Word Is Nothing Then Set Word = GetObject("", "Word.Application") End If Word.Application.Visible = True StartWord = True End Function |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remote Machine not available
Hello Alan
If the GetObject method returns an error, then you must use the CreateObject method. Your code uses the GetObject twice. You should amend to: On Error Resume Next Set Word = GetObject(, "Word.Application") ' If Word is not started, start a new instance If Err < 0 Then Set Word = CreateObject("Word.Application") End If On Error GoTo 0 Also, you should avoid using variables with names that could refer to an existing object in Excel: Set AppWord = instead of Set Word = HTH Cordially Pascal "Alan" a écrit dans le message de news: ... Sometimes the code below encounters a runtime error (462) at the line "Word.Application.Visible." That error says: "The remote server machine does not exist or is not available. What might cause this error? Alan Function StartWord() As Boolean StartWord = False ' Try to open an existing instance of Word On Error Resume Next Set Word = GetObject(, "Word.Application") On Error GoTo 0 ' If Word is not started, start a new instance If Word Is Nothing Then Set Word = GetObject("", "Word.Application") End If Word.Application.Visible = True StartWord = True End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
Macro doesn't run on new machine | Excel Programming | |||
RTD server on remote machine. | Excel Programming | |||
462 The remote server machine does not exist? | Excel Programming |