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.
How to create mutually exclusive radio buttons in word without using ActiveX control? To create a fillable word form, the content controls of Microsoft Word is very useful. Unfortunately the radio button control is missing from current content control toolbox. Here is an example of using Checkbox as the radio button. Create a table (2 rows, 3 columns) Insert 5 check boxes @ row 1, column 2, set their tags from opt11 to opt15 Insert 5 check boxes @ row 2, column 2, set their tags from opt21 to opt25 Paste below code snippet into ThisDocument code pane Option Explicit Private Sub Document_ContentControlOnEnter(ByVal ContentControl As ContentControl) Dim sOptNo As String Dim nOptNo As Integer Dim oCell As Word.Cell Dim oRng As Word.Range Dim oCtrl As ContentControl sOptNo = Replace(ContentControl.Tag, "opt", "") If sOptNo <> "" Then nOptNo = CInt(sOptNo) If nOptNo >= 11 And nOptNo <= 15 Then Set oCell = ActiveDocument.Table...
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>
Comments
Post a Comment