References or something else?

[Whistler]

Hi, I have build very advance (I believe ) Dashboard with several charts, contols, Date choosers and with ability to transfer to Power Point. I finished yesterday and everything works perfectly on my PC, but today I have tryied on two other PC's and I 'am gettnig diffrent faults, like Date choosers are not avilable thereare two crosses on their place or references missing on other PC.

How to make spreadsheet to be able to run it on every PC's? Mine will be in use for about 50 diffrent PC's, so I need to be sure that will work on all of them.

Thanks in advance

 

[RoryA]

Don't use controls that are non-standard for the versions of Office you want to support. If you have to, and assuming that the controls are licensed for distribution, you would need to create an installation package (Office does not have this ability, so you would need other software).

 

[GlennUK]

What Rory said is good advice.

Also, some controls may be available to Office Professional, but not be available to Office Standard ... if you have developed your dashboad under Office Professional, then it should only be delivered to users also with Office Professional.

 

[Whistler]

Thanks guys for quick answer. Do you have any documantation or link about how to create that installation package?

Thanks

 

[RoryA]

There are lots of different ones. I have no personal experience of any since I only develop in-house products, but Jan Karel Pieterse has a recommendation here.
Personally, I would simply avoid those controls altogether - much easier.

 

[Whistler]

I Can avoid, data chooser, this is my main concept of this Dashboard, that every one could adjust date to they requiremnts.

Thanks

 

[GlennUK]

Which particular Date Picker did you use?

 

[Whistler]

Hello GlennUK, I'm not sure which one it is, when I select it in design mode I get:

=EMBED("MSComCtl2.DTPicker.2","")

I found that it doenst work on one PC so far so I dont know if this is a real issue.

Thanks for your help

 

[GlennUK]

I think that's the one that's shipped with Access. Do you have Office Professional? And the problem PC only has Office Standard?

 

[Whistler]

My is MS office professinal plus 2007,

I don't know about the falut one, becasue I dont have access to it right now.

My company doesn't use Access, and Access is not installed on any of the PC's.

I will let u know which Office is the faulty one later.

Thanks