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.
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>
Color disabled in Windows 10 It is due to the Windows 10 color filters. To turn on or off the filter, press below key combination: Windows + CTRL + C It's a toggle switch.
Comments
Post a Comment