Excel addons

H

hustla7

Has anyone got any impressive excel add ons- in code format preferabl
to add to my system?? anything at all is fine- i just want to see wha
will look impressive for my IT coursework thanks in advance!
NITIS
 
M

Muhammed Rafeek M

Try this code to Install Addin

Private Sub AddIn_Install()


Dim SourceFile, DestinationFile, MyFile, lblMsg
On Error GoTo errMessage
MyFile = "\AddinName.xla"
Set tmpWB = Workbooks.Add
SourceFile = ThisWorkbook.Path + MyFile
DestinationFile = Application.LibraryPath + MyFile
FileCopy SourceFile, DestinationFile
AddIns.Add Filename:=DestinationFile
AddIns("AddinName").Installed = True
tmpWB.Close False
lblMsg = "AddinName Utilities has been successfully installed!" & vbNewLine
MsgBox lblMsg, vbOKOnly + vbInformation, "PharmARC Utilities"
Application.ScreenUpdating = True
Exit Sub
errMessage:
If Error > "" Then
MsgBox Error, vbCritical, "AddinName Utilities"
tmpWB.Close False
End If
End Sub
 
R

raypayette

It might be even more impressive if you found it yourself by using
search engine. :
 
H

hustla7

that code either doesn't work (unlikely) or i dont know how to work it
much more likely). thanx newway but ok- ill use google to fin
something! thanx Ray
 
M

Mike Middleton

hustla7 -
Has anyone got any impressive excel add ons- in code format preferable to
add to my system?? anything at all is fine- i just want to see what will
look impressive for my IT coursework thanks in advance! NITISH <
Click to expand...

I'm not sure my VBA code would be characterized as "impressive," but you
could download and examine the free, unprotected "Better Histogram" add-in
from http://www.treeplan.com.

- Mike
http://www.mikemiddleton.com
 
Top