haabids.blogg.se - Visual basic for applications access

The version will be the first line of information. Right click on vbe6.dll and choose "Properties"

If the directory is present you also have VBA version 6 installed.

Next, navigate to the \Program Files\Common Files\Microsoft Shared\VBA\VBA6 directory, if present. For example, after this patch is installed the version of vbe.dll will be 5.0.78.15. Right click on vbe.dll and choose "Properties"

If you see vbe.dll you have VBA version 5.

Navigate to the \Program Files\Common Files\Microsoft Shared\VBA directory.

Follow all of the steps below to determine which version(s) of VBA is on your machine:

It is possible to have both VBA version 5 and VBA version 6 installed at the same time. You will find a link to OfficeUpdate under the Related Resources links at the right of this page. If you are a Microsoft Office 2000 or Microsoft Office XP user, please obtain a patch for this issue from the Office Update site in addition to installing this patch. The update available from this page is for applications using Microsoft® Visual Basic® for Applications (VBA).