| Resource files expose any contained icons to Windows. By adding a resource file containing icons to your application and compiling, the user can select any of those icons to display in a shortcut to your application. Can't Create What Object Ever get this error (error 429) and wonder what object? Use this code to wrap your calls to CreateObject. It will return the name of the object that could not be created. Public Function fCreateObject(sID as String) as Object On Error Goto ErrHhandler Set fCreateObject = VBA.CreateObject(sID) Exit Function ErrHandler: Err.Raise Err.Number, "fCreateObject", Err.Description & ": '" & sID & "'" End Function Create a VB Add-In to Close all Open Windows in the VB IDE You can create a VB Add-In to close all the open windows in the VB development environment with a single click. Open a new VB project of type Add-In. Enter this code in the load event of frmAddIn. Press F2 to open the Object Browser, highlight the Connect class, right click it, and edit the Description field to change the name and description of your add-in. Also, search the entire project and replace all occurrences of "My Add-In" with whatever you decide to call it. Change the project's properties as desired. Make the DLL then you can add your add-in from the Add-In Manager. Dim w As Window For Each w In VBInstance.Windows If (w.Type = vbext_wt_CodeWindow Or _ w.Type = vbext_wt_Designer) And _ w.Visible Then w.Close End If Next |
Give Users More Icons With Your App |
India web developer web development India | Freelance web development ecommerce web developer | Prayagasoft - web designer India, Ecommerce developer india, Ecommerce design