Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 211
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 71
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost functionality to copy a formula across rows SandieB Excel Discussion (Misc queries) 1 March 21st 10 04:10 PM
Lost arrow functionality within Excel Mitch Excel Discussion (Misc queries) 1 March 5th 10 03:21 AM
Switched up to Excel 2007 lost functionality in my array equations Flcnmech Excel Worksheet Functions 0 February 10th 10 08:30 PM
Lost NETWORKDAYS functionality RC Excel Worksheet Functions 4 March 8th 06 03:55 PM
Upgraded & lost functionality Mike Savage Setting up and Configuration of Excel 3 March 20th 05 06:11 PM


All times are GMT +1. The time now is 04:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"