Excel 2010 Addin

Excel 2010 Addin

1. Installation folder
C:\Program Files\Microsoft Office\Office14\Library
or a network drive folder (Add it to the “Trusted Location” of Excel
2. Create a shortcut (change the icon)

Comments

Post a Comment

Popular posts from this blog

Error - vbe6ext.olb could not be loaded

Issue description: The target PC has both Office 2010 and 2016 installed, after uninstalled the Office 2016, and open an Excel Spreadsheet, the above error happened. Fix: Go to below folder: C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6 Rename the file "VBE6EXT.OLB" to "VBE6EXT.OLD”. Open Excel again, click Alt+F11, a popup window prompting for repairing, click "Yes". After repair completed, the problem is fixed also.
Read more

Visual Studio $(TargetDir) macro is empty

I encounter this issue in VS2017, it shall apply to older version also. To repeat the issue: 1. Create a PreBuildEvent, and type below script echo TargetDir = "$(TargetDir)" 2.  Build the project, you will see: TargetDir = "" Solution: Open the project file with a text editor, then remove the PreBuildEvent section, including the outer <PropertyGroup>. Then re-add the Pre Build Events using Visual Studio.   <PropertyGroup>     <PreBuildEvent>          <!-- Pre build commands go here -->     </PreBuildEvent>   </PropertyGroup>
Read more