12114:demo

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revisionBoth sides next revision
12114:demo [2024/04/15 04:45 UTC] – [Create the Tool Window Controls] mwolfe12114:demo [2024/04/15 04:47 UTC] mwolfe
Line 28: Line 28:
  
 ===== Create the Tool Window Controls ===== ===== Create the Tool Window Controls =====
 +Next, we're going to customize the controls that appear on the tool window.  I'll explain what these controls will be used for in a minute.  For now, all you need to know is that we are adding two text boxes and a command button.
  
   - Open myToolWindow.tbcontrol   - Open myToolWindow.tbcontrol
Line 76: Line 77:
 </code> </code>
  
-===== Build and Test the Addin on Same Machine ===== 
-The following instructions assume a machine with 32-bit Office (e.g., mjw20): 
  
-  - Ensure "**win32**" is selected in dropdown 
-  - **File** > **Build** 
-    * Creates and registers this file: ''M:\Repos\NLS\DevCon2024\Build\DevCon2024_win32.dll'' 
-    * As part of registration, the following registry key and values are created: 
-      * ''HKEY_CURRENT_USER\SOFTWARE\Microsoft\VBA\VBE\6.0\Addins\DevCon2024.myAddIn\'' 
-        * Description: "DevCon2024" 
-        * FriendlyName: "DevCon2024" 
-        * LoadBehavior: 3  ([[https://learn.microsoft.com/en-us/visualstudio/vsto/registry-entries-for-vsto-add-ins?view=vs-2022#LoadBehavior|3 => Loaded/Load at startup]]) 
-      * ''HKEY_CLASSES_ROOT\DevCon2024.myAddIn\CLSID'' 
-        * (Default): ''{9B80DA6E-8B20-4D53-AE54-430ACFAE987B}''  //(this matches the ''[ClassID()]'' attribute value above the myAddIn class in myAddIn.twin)//\\ {{:gb:fb:pasted:20240410-034733.png}} 
-      * ''HKEY_CLASSES_ROOT\DevCon2024.myToolWindow\CLSID'' 
-        * (Default): ''{D531346A-90B8-470D-AA33-FB009F19CEFD}''  //(this matches the ''[ClassID()]'' attribute value above the myToolWindow class in myToolWindow.twin)//\\ {{:gb:fb:pasted:20240410-034605.png}} 
-      * ''HKEY_CLASSES_ROOT\CLSID\{9B80DA6E-8B20-4D53-AE54-430ACFAE987B}'' 
-        * (Default): ''myAddIn'' 
-        * ''\InProcServer32'' 
-          * (Default): ''M:\Repos\NLS\DevCon2024\Build\DevCon2024_win64.dll''  //(<wrap important>NOTE</wrap>: The presence of win64.dll here is likely a result of running the win64 build as shown in the next section)// 
-          * ThreadingModel: Both 
-        * ''\ProgID'' 
-          * (Default): ''DevCon2024.myAddIn''\\ {{:gb:fb:pasted:20240410-035346.png}} 
-    * DEBUG CONSOLE should show this:  
-      * [LINKER] SUCCESS created output file 'M:\Repos\NLS\DevCon2024\Build\DevCon2024_win32.dll' 
-      * [LINKER]    -> Open Folder //(NOTE: this is a clickable link)// 
-      * [REGISTER] type-library registration completed. DllRegisterServer() returned OK 
-  - Open Excel or Access 
-  - Press [Alt] + [F11] to go to VBA IDE 
-  - Tool window will likely be floating; click and drag to dock it somewhere:\\ {{:gb:fb:pasted:20240410-032600.png}} 
-  - Enter ''Obj Name'' in the first text box, ''Coll Name'' in the second text box, then click [Create Collection Class]\\ {{:gb:fb:pasted:20240410-032714.png}} 
  
 ===== Build and Test the Addin on a Different Machine and Bitness ===== ===== Build and Test the Addin on a Different Machine and Bitness =====
  • 12114/demo.txt
  • Last modified: 2024/04/15 19:11 UTC
  • by mike