Creating a custom tool

[gaffar]

Hello

I want to create a add-in in VB 6.0 and include that add-in in the Ms-excel
sheet. can you give me a sample code for this.

My main aim is to create custom tool(Regression tool) using vb6.0 for
drawing and graphing . should exist as seperate application, ability to be
embeded into excel.

Regression TOOL
Specification : Take command line parameter as XML input file name. read
XML file containing 2 time series ,dates for series, residuals for
regression, regression parameters., current real and estimated values for Y
series, text summary as table. open a window with 2 charts and a summary.

i am new to VB so please guide me.

Thank u
Regards
Gaffar.

[Nick Hebb]

This MSDN article gives a basic overview of the process:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrbuildingcomaddinsforofficeapplications.asp

It's pretty general and only minimally helpful. Also, if you use
Firefox, switch to IE to read through it (I couldn't get the left menu
to work properly in Firefox).

The only book that I've found that touches on building COM Add-ins for
Excel is "Professional Excel Development" by Bullen, Boven, and Green.
It's a pretty good book, even though they only include 1 chapter on COM
Add-ins. Still, the sample code alone is worth the price of the book.