Workbooks for different versions of excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top