View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
MR From Texas[_2_] MR From Texas[_2_] is offline
external usenet poster
 
Posts: 4
Default Excel 2007 VBA Addin

Thanks MSweetG222

I cleaned the modules as you suggested, however, even though the cleaning
process was successful, it did not solve the problem.

MR from Texas

"MSweetG222" wrote:

MR From Texas,

Try "cleaning" the modules of the program in question. Rob Bovey has a
program to do this. Go to http://www.appspro.com/Utilities/CodeCleaner.htm
and download the program. I hope that works for you. Good Luck.
--
Thx
MSweetG222



"MR From Texas" wrote:

Thanks locochon.

The VBA Addin was developed by me, and has been in use for several months.

I have developed several other excel addins and had no problems like this one.

The message has occurred wih this Addin before and I have rebuilt the addin
and it worked correctly and without any problems, but all at once, this
problem started, then I went the backup file and it worked for a while and
then the same problem occurred.

I have since tried to open the file using the Custom IU Editor and I get a
message that the file is corrupted, however, I can open the Addin in Excel,
and it actually works with the Excel workbook. However, when I try to access
the Addin using the Addins Available dialog box, I get the message "Addin is
not valid".

Mr from Texas


"locochon2010" wrote:

Mr. Texas

1) You need to provide more information - Is it Microsoft or some third party?
2) You have to make sure your add in is properly installed.
3) I am not sure if you have to be logged in as an administrator to install
ANYTHING, even add ins.

"MR From Texas" wrote:

When I try to select a certain Addin from the Excel Options "Addins
Available" dialog box, I get a message that the "Addin is not a valid Addin.

Come someone advise me on what I should do?

MR from Texas