Add-in

F

Fox

For a professional software package we have created a xla to communicate
between the package and Excel. The strange thing is that this xla works fine
on machines in the US (Windows2000/Excel2000), but fails on machines in
Amsterdam (same system). On my machine (XP) the error message is: Runtime
Error 9: Subscript out of range". I have tested the xla on
Windows2000/Excel2000 as well on Windows XP/Excel2002 both without success.

Any suggestions....
 
F

Frank Kabel

Hi
you may post the relevant part of your code which causes this error.
Otherwise impossible to say
 
C

Charles Williams

My wild guess is that you are not using Option Compare Text, but as Frank
says we need to see the staement that causes the problem.
 
Top