Answers to ur questions:
1. excel 2003
2. References :
VBA for applications excel 11.0 object libraryOLE AutomationMicrosoft forms2.0
objects libraryMicrosoft ADO Ext. 2.8 for DDL and securityMicrosoft HTML Object
LibraryOutlook object libraryPowerpoint Object library3. Sub is in Module1
4. No, there is no other workbook open.