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


--
hustla7
------------------------------------------------------------------------
hustla7's Profile: http://www.excelforum.com/member.php...o&userid=37760
View this thread: http://www.excelforum.com/showthread...hreadid=574174

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

"hustla7" wrote:


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


--
hustla7
------------------------------------------------------------------------
hustla7's Profile: http://www.excelforum.com/member.php...o&userid=37760
View this thread: http://www.excelforum.com/showthread...hreadid=574174

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


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=574174

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 find
something! thanx Ray!


--
hustla7
------------------------------------------------------------------------
hustla7's Profile: http://www.excelforum.com/member.php...o&userid=37760
View this thread: http://www.excelforum.com/showthread...hreadid=574174

http://www.office-addins.com/-excel-addins/


--
hustla7
------------------------------------------------------------------------
hustla7's Profile: http://www.excelforum.com/member.php...o&userid=37760
View this thread: http://www.excelforum.com/showthread...hreadid=574174

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 <

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