you will need disk 1 of the install CD's for this.
Go to the VBA folder and right click over vba6.msi and install
Also place the .vba macro in the macro library.
Inside of Catia
Alt + F8
Pick Macro Libraries...
Change Library type to VBA projects.
Regards,
Derek