How to Fix the Default VBA Path Not Saving in Inventory App 2020

Key Takeaways

• This blog article that teaches how to fix the default VBA path not saving in Inventory App 2020.
• The issue is caused by a bug in the app’s code that prevents it from saving the VBA path in the registry.
• The fix is to manually edit the registry and add the VBA path as a string value in the Inventory App 2020 key.

Problem

Some users have reported that the default VBA path not saving in Inventory App 2020, which means that every time they open the app, they have to browse for the VBA file again. This can be frustrating and time-consuming, especially if you have multiple VBA files for different purposes. In this article, we will show you how to fix this issue and make the app remember your VBA path.

Solution to Fix the Default VBA Path Not Saving in Inventory App 2020

The fix for the default VBA path not saving in Inventory App 2020 is to manually edit the registry and add the VBA path yourself. This may sound complicated, but it is actually quite simple and safe, as long as you follow the steps carefully. Here are the steps to fix the default VBA path not saving in Inventory App 2020:

Step 1: Press the Windows key + R to open the Run dialog box.

Step 2: Type regedit and click OK.

Step 3: If prompted by User Account Control, click Yes.

Step 4: In the Registry Editor, expand the HKEY_CURRENT_USER folder by clicking on the arrow next to it.

Step 5: Expand the Software folder by clicking on the arrow next to it.

Step 6: Expand the InventoryApp2020 folder by clicking on the arrow next to it.

Step 7: Click on the Settings folder to select it.

Step 8: Right-click on an empty space in the right pane of the Registry Editor.

Step 9: Select New > String Value from the context menu.

Step 10: Name the new string value VBAPath.

Step 11: Double-click on the VBAPath string value that you just created.

Step 12: In the Edit String dialog box, type the full path of your VBA file in the Value data field. For example, if your VBA file is located in C:\Users\John\Documents\VBA\InventoryMacro.xlsm, then type C:\Users\John\Documents\VBA\InventoryMacro.xlsm in the Value data field.

Step 13: Click OK to save the changes.

Step 14: Close the Registry Editor by clicking on the X button in the top right corner.

Step 15: Restart the Inventory App 2020 by closing and reopening it.

Step 16: Check if the app automatically loads your VBA file. If it does, then you have successfully fixed the default VBA path not saving in Inventory App 2020.

Frequently Asked Questions (FAQs)

Question: What Causes the Default VBA Path Not Saving in Inventory App 2020?

Answer: The default VBA path not saving in Inventory App 2020 is caused by a bug in the app’s code that prevents it from saving the VBA path in the registry. The registry is a database that stores various settings and preferences for your system and applications. When you browse for a VBA file in Inventory App 2020, the app is supposed to save the VBA path in the registry, so that the next time you open the app, it can automatically load the VBA file. However, due to the bug, the app fails to do so, and the VBA path is lost.

Question: Is it safe to edit the registry?

Answer: Editing the registry is generally safe, as long as you follow the instructions carefully and do not change anything else. However, it is always recommended to back up the registry before making any changes, in case something goes wrong. To back up the registry, follow these steps:

Step 1: Open the Registry Editor as described in Step 1 above.

Step 2: Click on the File menu and select Export.

Step 3: Choose a location and a name for the backup file and click Save.

Step 4: To restore the registry from the backup file, double-click on the backup file and follow the prompts.

Question: What if I have more than one VBA file for the Inventory App 2020?

Answer: If you have more than one VBA file for the Inventory App 2020, you can create multiple string values in the registry and name them VBAPath1, VBAPath2, VBAPath3, and so on. Then, type the corresponding VBA paths in the Value data fields. The app will load the VBA files in the order of the string values.

Question: What if the fix does not work?

Answer: If the fix does not work, you may have typed the VBA path incorrectly, or the app may have a different bug that prevents it from reading the registry. In that case, you can try contacting the app’s support team or looking for other solutions online.

Summary

In this article, we have learned how to fix the default VBA path not saving in Inventory App 2020, a common issue faced by many users of this software. We have explained the cause of the issue, the steps to fix it, and some FAQs related to the topic. We hope this article has helped you solve the issue and enjoy using the app.

Disclaimer: This article is for informational purposes only and does not constitute professional advice. The author and the publisher are not liable for any damages or losses that may result from following the instructions in this article. Always backup your data and use caution when editing the registry.