start learning Excel/VBA, where to start from? Any online video lectures?

[cfman]

Hi all,

I start to learn Excel/VBA... and I know VBA is intimately related to VB, so
I guess I have to learn some VB too...

NOw the question is: from where do I start? From VBA, then Excel, then go to
VB...

or from VB, and then VBA and Excel?

Also, when I learned C++, there are many good online C++ classes from good
universities, so I can educate myself by watching those video lectures from
some universities and that's a good distant learning... It helped greatly
because when it comes to getting familiar with VC++ studio, etc, GUI
debugger, etc., it is a lot better to watch a hands-on teaching...

But when it comes to VBA/Excel/VB, I did not find any (free) online classes
that I can watch and self-study. I guess that is because universities don't
teach VB/VBA/Excel... is that true? So from where can I find some good
resources and study-aids that can greatly facilitate my study?

Thanks a lot!

 

[julian]

hi,
there are a lot of material on macros on the internet. I'm sure you
know how to use the search engine to find these materials. If you need
a good book try Excel power programming by J Walkenbach

regards,
Julian

 

[Rick]

Well since your main objective is VB6, star with VB6.
First create an Excell object:

Dim AppExcel as Object
set AppExcel = CreateObject("Excel.Application")

....
///...................//....
....

AppExcel.Close
Set AppExcel = Nothing


In the middle write what you need the Excel Object to do.
I usually play around with MS Excel Macro recorder and see what it writes on
the Module.

Then I adjust the code to VB6 - of course it's not exactly the same! But
very similar.
And go from there.

I would recommend to look around internet to see some examples.

 

[David Heer]

The <A
href="http://msdn.microsoft.com/library/d...ml/xltocObjectModelApplication.asp?frame=true"
target="_blank">Excel Object Model</A> is a handy resource for Excel VBA.

 

[David Heer]

Uh-oh... My HTML is showing...

/embarrassed

 

[cfman]

Well since your main objective is VB6, star with VB6.
First create an Excell object:

Dim AppExcel as Object
set AppExcel = CreateObject("Excel.Application")

...
///...................//....
...

AppExcel.Close
Set AppExcel = Nothing


In the middle write what you need the Excel Object to do.
I usually play around with MS Excel Macro recorder and see what it writes
on
the Module.

Then I adjust the code to VB6 - of course it's not exactly the same! But
very similar.
And go from there.

I would recommend to look around internet to see some examples.

My main goal is VBA/Excel,... but you said VB6, what's the relation between
VB6 and VBA?

 

[Karl E. Peterson]

My main goal is VBA/Excel,... but you said VB6, what's the relation
between VB6 and VBA?

They're both based on the same fundamental language, however one (VBA) is
targetted at application automation and the other (VB6) is designed to
produce standalone applications and applicaton extensions (DLLs). To some
extent, you can cross over a bit. Well-written code, outside external
object models, is often cut/paste compatible.

 

[Cindy M.]

Hi Cfman,

I start to learn Excel/VBA... and I know VBA is intimately related to VB, so
I guess I have to learn some VB too...

NOw the question is: from where do I start? From VBA, then Excel, then go to
VB...

or from VB, and then VBA and Excel?

If you want to program Excel AND you don't want to pay for anything, then I
recommend the excel.programming newsgroup as the first resource. From there,
follow links to websites and blogs you find in posts. There are quite a few
Excel-programming sites.

Since you have a reasonably strong programming background, you should pick up
the syntax quickly enough. Getting onto a first-name basis with the object
model will be the bigger challenge: the examples you find in the discussions
and on the sites should help you along with that

One of the best written resources is "Professional Excel Development" by
Bullen, Bovey and Green, from Addison-Wesley. This is NOT beginner-level, and
it's not free

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[JE]

If you want to program Excel AND you don't want to pay for anything, then I
recommend the excel.programming newsgroup as the first resource. From there,
follow links to websites and blogs you find in posts. There are quite a few
Excel-programming sites.

why don't you check this site http://www.avaxhome.ru/ebooks/ it has a
pile of books(PDF) for VBA and Excel.