References query

[c.p.morris]

Help !!!!

I have written an Excel spreadsheet which has been distributed to our clients, but 3 out of about 50 are giving an error 'compile error in hidden module: this workbook'. I can't reproduce the error on any of my test PC's so until I visit the client and unprotect the macro I can't say what it stoping it running. But before I do that I want to get some ideas what could cause it on odd PC's. I wonder if it may be that there is a file (dll, ocx, tlb, etc) missing on these PC's.

So, my question is: When References are selected in MSVB in Excel (Tools, references) are they attached to the Excel file, if not then would I have to make sure they are on the clients PC?

If I understand it right, the required files need to be registered. Is there a way of listing registered files on each PC?

Any helpful advice would be much appriciated as I am new to this (as if you can't tell !!)

[Br1an_g]

whilst in the vb editor of Excel:

Tools>References.

take a note of what is listed for a PC that the macro works on.

then compare it to a PC where the macro does not work

see if there are any differences.

HTH

[c.p.morris]

Thanks Br1an_g,

If there are any not listed is it ok to copy my files onto another computer and register them with regsvr32.

Will this work for different operating systems and different office versions?

Thanks

[Br1an_g]

[EDIT] yeh if its not on the list, copy the file over and register it manually.

different office version have different versions of the same reference..

e.g. my Excel install has Microsoft Excel 10.0 object library (XP)
Excel 97 has Microsoft Excel 8.0 object library. (from memory)

i am unsure if you can copy newer version references into older installs...

OS wise, im pretty sure if you have 97 on an xp machine, and 97 on an NT machine the actual install is identical.

[c.p.morris]

Many thanks Br1an_g. Will need to visit client to try to solve as I can't replicate here.