HomeEnd User SetupConfiguring ExcelVisual Basic for Applications

2.2. Visual Basic for Applications

Disponible en español: Visual Basic para Aplicaciones

Applies to: Palisade software used with Excel, releases 5.x–7.x

Does Palisade software use Visual Basic? How do I install that on my computer?

There are actually two things called Visual Basic: Visual Basic for Applications, which is part of Microsoft Office, and the Visual Basic 6 Runtime, which is part of Windows. Both are needed for most Palisade software; this article is about Visual Basic for Applications (VBA).

All Palisade products except the Palisade Custom Runtime use Visual Basic for Applications (VBA), which is a component of Excel in Microsoft Office. In a normal install of Office, VBA is installed automatically. However, sometimes people doing a custom install of Microsoft Office will change options to exclude VBA. Excel installed in that way will not support our add-ins.

To make sure you have VBA installed, launch Excel and press Alt+F11. If the Visual Basic Editor comes up, you have VBA. If it does not, close Excel and enable that feature in Office. The exact process varies with Office and Windows versions, but it will be something like this:

  1. In Control Panel » Programs and Features, locate Microsoft Office, right-click it, and select Change.
  2. On the next panel, select Add or Remove Features.
  3. Under Office Shared Features, set Visual Basic for Applications to Run from My Computer. Click Continue.
  4. If the installer says that you need to restart Windows, do so. If the installer doesn't prompt you to restart Windows, then there is no need.

See also: Visual Basic 6 Runtime

Last edited: 2017-05-16

This page was: Helpful | Not Helpful