SW2021sp2 installation error; can't upgrade VBA7.1

I've tried to remove SW2020 and install SW2021sp2 however following error makes me crazy because it complaining can't upgrade VBA anyhow

I've tried different ways to upgrade or remove manually the older version, but no success
also, I upgrade my office from 2007 to 2012  but no luck

any help really appreciated
 

SolidworksGeneral
Answers 1
JN
JN 2021-04-09

This reply is late, but maybe it will help someone in the future.  There is a script in Knowledge Base Solution S-078838 that removes the VBA components from your machine. Once the remnants of past VBA installation is removed, you should be able to get past this and similar VBA 7.1 errors during installation. Note that if you have multiple versions of SW installed at the same time in a side x side setup, you may need to repair the other installations to get the needed VBA 7.1 back on yout machine.                    Download the attached file ‘S-078838_uninstall_vba.txt’.
 Rename the file to ‘S-078838_uninstall_vba.bat’.
 Right-click the ‘S-078838_uninstall_vba.bat’ file and then click ‘Run as administrator’.