remote activex excel access

[Darkdave]

Hi,

I just developp an Client-server application for Data converting using an Excel ActiveX server.

My exe stand on my client opening an excel Session through Activex controls on my server.

I precise that only my server  has an Excel licence.

When running  it seems the NewApp.. function wihch had the correct IPadress parameter of the server

returns me the error "Interface not supported" and gives no available handle.

The TCPIP procotol works (pinged) well, the application works (if paths are modified) if it's installed in "standalone"

on the server.

It seems it felt something regarding Excel Active X on my client (OCB, Dll, Registry entry) But I cannot find it.

Got anybody the same probleme regarding direct IP adress access using active X ?

Thanxs in advance

David

[shahina]

Hello David,

Which version of the Microsoft Excel Object Library are you using and which version of Excel do you have on your server? Can you launch Excel on your local machine fine? Could you post your code that is giving this error?

Also, you could try running the sample program excel2000dem at C:\Program Files\National Instruments\CVI71\samples\activex\excel changing the first argument of Excel_NewApp() to your IP address, and see if you get the same problem.

Good luck and best regards,
Shakhina P.
Applications Engineer
National Instruments

[Darkdave]

Hi Shahina,

So to explain you a bit. My application has been developped on a standalone machine. So it call the excel ActiveX functions

of my developpment pc on which I got an excel licence. I try using the IP adress of my local machine ... it works fine.

To deploy my software, I install the application on my clients but try to point to my Server on which I have an excel licence.

I though I only need to put the server IP adress on the ExcelNewApp function then I get the message.

So the general questions is how to use an activeX server (Word Excell...) in remote access. I mean an excell licence on each client should fix the problem.

But that's not the goal. So what need my client (key registry, dll, dll object) to get an application handle.

But I'm not really sure it can works without an ecell license on each client.

Thanks a lot

[Mohan]

The "interface not supported" error indicates that COM is not able to "marshal" the Excel interface. This is probably because the Excel interfaces are not registered on the client machine. One obvious way to get these interfaces registered on the client machine is to install Excel on the client machine - but you have indicated that you cannot do this. There might be some solution from Microsoft to get these interfaces registered on your client machine without installing Excel - you probably want to search/ask for this on MSDN, Microsoft newsgroups/support groups, etc. I think you can do this by registering the Excel typelibrary file on your client machine - but I am not completely sure. The Excel typelibrary file on my system is C:\Program Files\Microsoft Office\OFFICE11\XL5EN32.OLB, but it could be different on your system based on the version of Office, etc. I think one can register typelibrary files using the "regtlib" windows command.

[Darkdave]

Hi Mohen,
U completly right. But I'm not sure it came from the Typelib object  of Excel. IE: this is not error I get.
But it could arrive maybe after... cos this libriry is not registred as you said.

For the moment I fix my problem using a routine on my client which works as a task scheduler,
Getting itself the files through the network & converting them from the server.

So I was just curious to solve this problem and I was surprising finding no posts regarding this kind of problem.
I mean activeX has more interest when it's used with remote acess... Only to use one licence.

I'll try to get some responses using the MSDN forum. That way, I'll maybe post something else such like a solution to do
this kind of job using microsoft Active X prowares.

Thanks for the explanation and best regards.

David Thuilliez