13 type mismatch help
 

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

13 type mismatch help
 

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

--

HTH

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


"Mike K" wrote in message
...
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

13 type mismatch help
 

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

"Bob Phillips" wrote:

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

--

HTH

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


"Mike K" wrote in message
...
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