I was going to suggest this book. It's the best Excel development book there
is.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Doug Glancy" wrote in message
...
Matthew,

You should take a look at Professional Excel Development. It has good
content on calling VB6 dlls from Excel:

http://www.amazon.com/Professional-E.../dp/0321262506

Once you've got the mechanics of that down, it's not much different from
coding VBA.

hth,

Doug
"Matthew Dodds" wrote in message
...
I've used VBA code to automate various Excel data analyses and
charting. For code security's sake I'd like to transfer most of this
functionality into DLLs. (And, to be honest, as an exercise for
learning VB6 - yes I know VB6 is now unsupported and we're all
supposed to be seguing to .NET but frankly where I work we'll transfer
to .NET no time soon)

Question is - where to start? Right now my my VBA coding is functional
& I've got Paul Lomax's 'VB and VBA in a Nutshell'.

What would everyone's recommendations be on
- other books? Visual Basic 6 Core Language Little Black Book: The
Indispensable Guide of Day-to-Day VB6 Programming Tips and Techniques
(Paperback) by Steven Holzner (Author) is one that has caught my eye,
As has Code Complete: A Practical Handbook of Software Construction
(Paperback)
by Steve McConnell (Author) 900 pages $26 ... a little ambitious,
perhaps, but learning about good design structure presumably no bad
thing.

- software; Enterprise edition of VB6? or Visual studio? Which would
be best? why?

- and has anyone some recommendations for neat tutorials out there?
I've digested ChipPearson's 'Creating a COM Addin', and the ms pages
http://support.microsoft.com/kb/238228 &
http://support.microsoft.com/?id=291392;
needless to say ChIP's was the most comprehensible. Are there any
sites for taking this further?

Many thanks in advance

Matthew