13 type mismatch help

[Guest]

Oh wise ones,
I have some code with several macros (one runs every 2
seconds constantly). It was developed and runs fine on the two machines in
my lab. One is on Win 2000- excel 2000, the other on Win XP-Excel 2003. I
have successfully got my sheet to run on one 2 other machines outside the
lab, but there are 2 other machines where it will not run. It generates a "13
type mismatch" when starting up and will not access the sql server and
retrieve the data. Why would it run on one machine and not another if the
main setups(XP,2003) were the same. I am the logon ID each time also. ANy
ideas?

Mike

 

[Bob Phillips]

Do those other machines/users have access to the SQL Server?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Bob,

Yes. They can use the main front end to the database called "Active
Factory". It's the add-in they wrote for excel that wants to be difficult.

Mike