Workbooks for different versions of excel

M

Mike

I have an excel form to be accessed from our intranet that was designed in Excel 2000. When I test it with older versions of excel I get lots of run time errors yet it works fine on my own machine. I have saved the file using the Excel 97-2000 option (This covers all of the versions being used) but I am still getting run time errrors when using it with older versions. Can anyone help?
 
D

Dave Peterson

Do you have any references to libraries that are version specific? You can see
the references in your workbook via the VBE, tools|references.

If you have references to, say, Word2000 (Word 9.0), you may want to use late
binding--remove the reference and use createobject.

If that's not close, you may want to post a snippet of code that causes the
problem.
 
Top