Best General Add-In Challenge

Aaron Blood said:
After the 100th person asked me about the #NAME? errors I had to just start including it in every workbook. :banghead:

If it were up to me, this may be the winner. If it was converted to an add-in. :D

You may want to force a Calculation as well, just in case.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Yes Aaron, I had the same problem with users who did not install the MS Query Add-in and the ODBC Driver Add-in. I would create great queries and place them on the share drive, and would get numerous complaints that they did not work. I used

<font face=Courier New><SPAN style="color:darkblue">Private</SPAN> <SPAN style="color:darkblue">Sub</SPAN> Workbook_Open()
<SPAN style="color:darkblue">If</SPAN> Application.AddIns("MS Query Add-in").Installed = <SPAN style="color:darkblue">False</SPAN> <SPAN style="color:darkblue">Then</SPAN>
    AddIns("MS Query Add-in").Installed = <SPAN style="color:darkblue">True</SPAN>
    <SPAN style="color:darkblue">End</SPAN> <SPAN style="color:darkblue">If</SPAN>
    <SPAN style="color:darkblue">If</SPAN> Application.AddIns("ODBC Add-in").Installed = <SPAN style="color:darkblue">False</SPAN> <SPAN style="color:darkblue">Then</SPAN>
    AddIns("ODBC Add-in").Installed = <SPAN style="color:darkblue">True</SPAN>
    <SPAN style="color:darkblue">End</SPAN> <SPAN style="color:darkblue">If</SPAN>
<SPAN style="color:darkblue">End</SPAN> <SPAN style="color:darkblue">Sub</SPAN>
</FONT>


I must admit, the "You are an idiot" message is classic, although most of my users are instructionally challenged(i.e.Upper Management)
 
If You want to find the #NAME?


Public Sub Forum_Open()

Dim User as Forum.Memberlist

For Each User in Forum.Memberlist.Count
If User.Location="West Palm Beach, Florida" Then
MsgBox "freakin idiot Found!"
MsgBox "freakin idiot Name is=" & User.Name
Exit For
End if
Next User

End sub
 

It was just a joke.
I'll assume that as an attempt at the same...
 

just a joke :-D
 
I figured you were joking...

I mean anyone who would use their )( as an IO port has to have a decent sense of humor.

(I know, I have no business poking fun at someone's name. BUTT I just couldn't resist.) :diablo:
 

Well. That's just not nice. :cry:
 

Forum statistics

Threads
1,226,452
Messages
6,191,133
Members
453,642
Latest member
jefals

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top