There are 2 ways to check what service pack you are currently using in your loaded version of Catia V5.
1) In Catia V5 Help/About Catia and in the pop up window there will be listed the current version of Catia, including the service pack number.
2) If you are not in Catia, you can Start/Programs/CATIA/Tools/Software Management
If the macro was written for service pack 6, it probably won't run in service pack 5, but I've never tested this. A drawing created in service pack 6 will not be able to be opened in service pack 5 though.
Good Luck!