I believe this is a 32 bit components and if I'm not mistaken Excel has VB6 (x32 based) and SW 2012 onwards is on VB7 (x64 based). Do have a x64 component for SAP BAPI? What version of Visual Studio are you using? Try to unchecked 'Prefer 32 bit' and target to Any CPU - and if that fill show an error - this is the case.
Bingo, As soon as I changed the target to any CPU I received the same error. Now that I know what to look for it seems there are solutions.
Thanks for your response. You have helped a lot of people on this forum.
the solution I saw on the internet did not work. Is there a way to create a 32 bit object from in the SolidWorks API?