Problem with CreateObject

[QAQ]

Hi all ,
Im using the following piece of code in MS Excel:

' Declare an object variable to hold the object
' reference. Dim as Object causes late binding.
Dim ExcelSheet As Object
Set ExcelSheet = CreateObject("Excel.Sheet", "RB-COMPUTER")
' Make Excel visible through the Application object.
ExcelSheet.Application.Visible = True
' Place some text in the first cell of the sheet.
ExcelSheet.Application.Cells(1, 1).Value = "This is column A, row 1"
' Save the sheet to C:\test.xls directory.
ExcelSheet.SaveAs "C:\TEST.XLS"
' Close Excel with the Quit method on the Application object.
ExcelSheet.Application.Quit
' Release the object variable.
Set ExcelSheet = Nothing

...Which you can tell is straight out of the help file.

The problem is that I get an error on the following line of code:

Set ExcelSheet = CreateObject("Excel.Sheet", "RB-COMPUTER")

The error reads: "Run time error '462'. The remote server machine does not exist or is unavailable"

Now, I have a network setup between my PC and the other PC called "RB-COMPUTER".

Where am i going wrong? Please help.

 

[SkipVought]

Hi.

"The problem is that I get an error on the following line of code:

Set ExcelSheet = CreateObject("Excel.Sheet", "RB-COMPUTER")"

Well seems you cheated a bit. The example is in regard to "the version number of an instance of Excel running on a remote computer named MyServer:"

The key phrase thus emphasized...

Dim xlApp As Object
Set xlApp = CreateObject("Excel.[b]Application[/b]", "RB-COMPUTER")"

Skip,
[sub]
When a wee mystic is on the loose..
It's a Small Medium at Large! [/sub]

 

[QAQ]

Hi SkipVought,
Thanks for the reply. I tried your code and it still doesnt work - the same error comes up. The PC I am running the code from has windows vista and the other pc (rb-computer) has windows xp. Previously the windows vista pc used to have xp on it. and even then it never ran.

Can someone help please?

Thanks
Regards

Q

 

[SkipVought]

This seems like the kind of thing that you're going to have to experiment with persistently to discover a solution.

No one else has your environment.

However, you may be lucky and get a reply some guru.

Skip,
[sub]
When a wee mystic is on the loose..
It's a Small Medium at Large! [/sub]

 

[QAQ]

thanks

 

[CautionMP]

QAQ,
The following refers to VB 6 specifically, but since VBA/VBScript are variants of...

The documentation for the CreateObject function does not mention that the server referenced in the servername argument must be a Windows NT or Windows 2000 server.

DOC: CreateObject Documentation Using Servername Argument​

CMP

 

[QAQ]

Thank You CMP! That explains a lot!

 

[QAQ]

So...is there another function that does the the same thing ... or is there another way around to do the same thing?