Wednesday, June 26, 2013

Error: VBA6.dll not found

I had a situation at my customer place wherein Office 2010 is installed and after uploading VBA customization for Dynamics GP, we were receiving the error 'VBA6.dll not found'. There are two solutions for this.

Solution I

  1. Unistall Office 2010
  2. Take a complete GP customization backup.
  3. Uninstall GP
  4. Install GP
  5. Import the customization package which is backed up in Step 2.
  6. Install Office 2010
Solution II

  1. Take a complete registry backup.
  2. Install VBA 6.4 Core Components. You can download this from https://mbs2.microsoft.com/fileexchange/downloadfile.aspx?fileid=2208ac6f-d575-4f34-8b19-40340fe3d20c
  3. Open GP.
  4. Take a complete GP Customization backup. Please note that you should not include any References while taking this backup.
  5. Close GP.
  6. Open the folder where GP is installed. By default, it will be C:\Program Files (x86)\Microsoft Dynamics\GP2010 for 64-bit and C:\Program Files\Microsoft Dynamics\GP2010 for 32-bit machines.
  7. Delete all .vba files which are of 4KB size. You can even move them to another folder.
  8. Rename all .vba files which are of above 4KB size.
  9. Open GP.
  10. Import the customization package which is backed up in Step 4.
  11. Add References using Visual Basic Editor if needed.
  12. Close & Open GP.

No comments:

Post a Comment