Programming tricks (Apr 2018)


Programming tricks (Apr 2018)

1. How to create an Icons DLL like the “Shell32.DLL” which make its icons visible for shortcut icon setting, and how to use its icons for shortcut via codes

2. How to create a professional MSI installer via Visual Studio Windows Installer (User Interface, Custom Actions and Installer Class)
Create Shortcut on desktop for every user or current user
Create Shortcut under StartMenu

3. The limitation of InstallShield Limited Edition

4. The WiX open source Toolset for Visual Studio

5. Office Addin and Ribbon (XML), finally get the trick to hide all unwanted menu Tabs include “FileTab”

6. Expose .Net functions to Office VBA via type library or Addin

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