VBA Functionality Lost
 

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?
--
Thanx in advance,
Best Regards,

Faraz

VBA Functionality Lost
 

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

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

Either one of the DLL is corrupted of the PC is using the wrong folder
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 PC
to the bad PC.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=173794

Microsoft Office Help

VBA Functionality Lost
 

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

"Faraz A. Qureshi" wrote in
message ...
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?
--
Thanx in advance,
Best Regards,

Faraz