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

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

I've got a little example VB6 DLL that is invoked from Excel. It is the full
package, VB6 code, an executable, and an Excel test harness. If you would
like, I can send you a copy. Is that a valid email?



--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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

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

On 24 May, 00:14, "Bob Phillips" wrote:
I've got a little example VB6 DLL that is invoked from Excel. It is the full
package, VB6 code, an executable, and an Excel test harness. If you would
like, I can send you a copy. Is that a valid email?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MatthewDodds" 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

Not for the first time I think praise be to this newsgroup; thank you
Doug, Jon, Bob for your responses. I should have known to look out for
the book you recommended; I have their Excel 2000/Excel 2002 VBA
Programmer's Reference (Wrox Press) and it's the most well thumbed
book in the house.

Bob, yes that's a real email, and thank you for your kind offer - I
suspect I'm not yet able to make good use of it, but please yes, that
would be very helpful. What does it do? I'd like to be able to view
the code so I can understand better - hope that can be possible, once
I sort out the software-to-buy issue. Thank you.

My remaining unaddressed issue (besides trivial matter of the VB6
learning curve, lol) is software package availability, versions and
recommendations; I'm a bit at sea as to what distinguishes the various
editions - can anyone offer a quick precis & recommendation? I want to
be able first and foremost to write in-process DLLS for Excel, to
create installation packages (if that's the right terminology) so
their distribution is idiot proof, and to be able to release time-
limited versions so they go dead after a trial period. (I've just come
across "Microsoft Visual Basic Enterprise Edition - ( v. 6.0 ) - media
- CD - Win - English." at less than £30 - shurely shome mistake?))

What would the group recommend?

Thanks in advance for your contributions, and enjoy the weekend.
Matthew