Excel VBA compatability

[SQLScholar]

Hey,

I have 2 problems to solve on a tool i created in excel.

1) Someone said they couldnt save the tool with excel 97 saying that some features are not compatable with file format. Although on my Excel 97 it saves fine. What features are/aren`t compatable?

2) In a peice of code (VBA) i have it sends an email to me if people have problems. It uses the code from the Outlook reference. How can i inlcude the version of excel in the subject.

TIA

Dan ----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[RobBroekhuis]

The second question is straightforward, so I'll answer that one ;-)
application.version
gives the version as a number. E.g., Excel2000 is 9.0
I'm not sure what is the best reference for version compatibility between different Excel VBA implementations.
Rob