problem with spreadsheet control

[lopko]

Hi all, can anybody help me with following problem, please?
In one interface I'm using Microsoft Office Spreadsheet 9.0 control, where the user can input some data. Problem is, that when I send this file with this interface to another machine, the spreadsheet disappears. (funny is, that this happens only when the other machine runs on Windows XP system). By opening this file, it appears message: "some objects could not be load" and these object are mentioned spreadsheets in that interface.

Thank you for every advice.

Lopko

 

[asjeff]

Hi Lopko

I suspect, but can't be certain, that the MS Office spreadsheet control is not loaded on the XP computer which might be a reason why you are having this problem. What version of Office does the XP computer run? I would try copying the control from your good computer & registering it on the XP one to see if that makes a differrence. Afraid I don't have other ideas about what it could be.

Hope this helps

Asjeff

 

[lopko]

Hi asjeff,

thanks for your advice, that's really this problem. Now I understand it little bit better, but...

I was on that machine, which runs on Windows XP and there are Microsoft Office Spreadsheet 10.0 and 11.0 controls no 9.0 control. Now I know, that I need one concrete .dll file (I know which concrete one ) ) which handles this control and of course it isn't on that XP machine. Therefore it doesn't work. I can manualy add a reference to this .dll file and it works after this step. But this was possible to do now, when this XP machine is in next building, it will not be possible to do, when another machine will be in next town )

My question is. Is it possible to send this .dll file together with file which contains the interface with the relevant spreadsheet control and some automaticly add the reference before initializing the interface (in auto_open procedure). I need the command, which can execute this, if it's possible.

Thank you for every reaction

lopko