Microsoft Visual Basic Runtime Error 53 On A

  1. Microsoft Visual Basic Runtime Error 53
  2. Microsoft Visual Basic Runtime Error 53 On A Mac
  3. Microsoft Visual Basic Runtime Error 53 On A Chromebook

Symptoms

When user clicks Smart View toolbar in the Addins tab on the Ribbon the following error message appears:
Microsoft Visual Basic
Run-time error '53':
File not found: HsAddin

Cause

In other words, if you installed onto a different pc, the app is looking for a database in a folder the same as to where you saved it on your own pc. If the installed pc and the development pc is the same, your app. Is looking for another file not saved in the correct folder. Check all your files that was added to the setup to your actual. We have released a couple of fixes related to this issue with the Solver32.dll file, caused by the initialization of Power Query and Power Pivot.

Smart View addin has been disabled by Excel.
Runtime

Solution

First try to re-enable Smart View add-in using Excel's user interface:
Office 2003:
  1. Help -> About Microsoft Office Excel
  2. Choose Disabled Items...
  3. Select SmartView and choose Enable
Office 2007:
  1. Office Button -> Options...
  2. Select Add-Ins at the left
  3. In the Manage drop-down menu at the bottom, select Disabled Items
  4. Choose Go...
  5. Select SmartView and choose Enable
If Smart View is not listed in the Disabled Items dialog box, a Windows Registry modification will be necessary to resolve the issue.

Microsoft Visual Basic Runtime Error 53


Note:
Make sure you have a backup copy of Windows Registry, before attempting to make any changes in it.

Microsoft Visual Basic Runtime Error 53 On A Mac

In Windows Registry find following key HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0ExcelResiliency and delete the entry pointing to the HsAddin.dll:
  1. Open RegEdit
  2. Navigate to HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0ExcelResiliency
    (Note: This location refers to Office 2007. If you have Office 2003, substitute 11.0 for 12.0 above. Substitute other versions as necessary)
  3. Locate the value, which will have a random name, that points to HsAddin.dll. The path is in Unicode characters but if the path contains English or European characters can usually be identified if you double-click each value in turn -- the path can be read at the right of the dialog box. Read every other letter.
  4. Right click the value and choose Delete.
  5. Repeat for HKEY_LOCAL_MACHINESoftwareMicrosoftOffice12.0ExcelResiliency if it exists.

Microsoft Visual Basic Runtime Error 53 On A Chromebook


Reference:
Smart View Error 'Run-time error '53': File not found: HsAddin' when Clicking on Smart View Toolbar (Doc ID 875795.1)