How to Troubleshoot a VBA
Visual Basic Applications are developed with the Visual Basic programming language. These applications are used for everything from Web development to Microsoft Word reports. VBAs are generally used with Microsoft Excel, AutoCAD, WordPerfect and ArcGIS to control user interfaces or custom user forms. If you are having problems with your VBAs, there is a couple of things that you can do it get them working again.
Other People Are Reading
Instructions
-
Upgrading and Repair
-
1
Upgrade your VBA Reflection software to 10.0.2 or higher. Reflection is the software used for "plugging in" your application to another software package like WordPerfect or Microsoft Excel.
-
2
Repair your Reflection software. Click the "Start" button and then click the "Control Panel" icon. Click on the "Add or Remove Programs" icon and then choose your "Reflection" icon from the list of programs listed. Click the "Click here for support information" link and then click the "Repair" icon.
-
-
3
Repair the "MSI" file. Click the "Start" button and then click on the "Run" box. Type "MSIEXEC /focums <paths>\<Reflect>.msi" into the "Run" box and then press the "Enter" button. Wait for the system to replace the MSI file.
Verify Registry Permissions
-
4
Verify the registry permissions. Click the "Start" button and then click the "Run" box. Type "regedt32" and click the "OK" button to open your Registry Editor.
-
5
Click on the "HKEY_LOCAL_Machine" icon and then click the "Software" icon. Click "Microsoft" and then click the "Shared Tools" icon. Click on "MS097RT."
-
6
Click on the "Permissions" icon and then click "Everyone" from the "Name list" to turn on the permissions.
-
7
Check the boxes next to "Query Value," "Set Value," "Create Subkey," "Enumerate Subkeys," "Notify" and "Read Control." Click on the "OK" button twice to save the changes.
-
8
Exit the "Registry Editor."
-
1
