VBA Functionality Lost

F

Faraz A. Qureshi

On one of my office computers whenever I try to open one of the add-ins I am
notified that the ActiveX Controls & VBA part is lost. Even VBE doesn't open.
Could there be some kind of restriction implemented by the Administrator? How
to have the same functioning?
 
J

joel

The Active-X components you DLL. To find out which DLL are being use
if you go to the VBA menu

Tools - References you will see the a list of libraries used by th
project. The DLL for those object. If you select each of the librarie
with the mouse the name of the DLL will appear on the bottom to th
dialog box.

Either one of the DLL is corrupted of the PC is using the wrong folde
for the DLL. go to a good machine and get all the DLL's being used.
The go to the bad PC and browse for the DLL for each of the libraries.
This may fix the problem.

If the DLL is corrupted/missing you could copy the DLL from a good P
to the bad PC
 
R

Robert Flanagan

The problem is a bad installation of Office. VBA has been removed,
corrupted or not correctly installed. Un-install Office. Run the temp file
deleter at http://www.add-ins.com/temp_file_deleter.htm before re-installing
to delete temp and exd files that may result in a bad installation. Reboot.
Re-install. Do all updates.

Robert Flanagan
Add-ins.com LLC
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Top