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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Older versions of Excel 5
Workbook used as pricing calculator 4
Excel How to enable engineering functions in MS Excel 2000? 3
Saving a newer version of Excel using an older version (Excel 97) 7
Excel 2003 file conversion problem 2
Seeing Two Different Excel Files At Once: How, please ? 2
Protect Worksheet to share with older versions of excel 2
File size issues 1

Back
Top