Solidworks API to Excel VBA

I'm trying to create an automatic part selector in an excel workbook.  The idea is that the User will enter info into excel and a button will be generated with a link to a library part.  I have the code functioning in the SW API, to open the part or assembly, but when i c&p the code into the Excel VBA i get an [object doesn't support this property or method] error.  Reference libraries match and the code matches.  Can anyone comment on my hang up?

Thanks,

Michael ---> [API Novice]

SolidworksApi macros