Learning VBA (Office 2000)

Topic

New Reply

I am really only wanting to use VBA with Access & Excel. My “knowledge” consists of recorded macros with a bit of tinkering and that’s all (plus some nice bits that I pick up off of here). So I really need to get the fundamentals into my head.

My company are willing to shell out

Reply | Quote

Replies

If there is a good course available with a good instructor, and someone else is willing to pay for it, that is definitely the best way to go.

Reply | Quote

TearsInTheRain

STOP it right now Legare is right. And I would add to his suggestion some more recording and some more tinkering.

Try and think of a project, heck write an application that would emulate an ATM (Automated Teller Machine), where you can withdraw funds from your bank accounts and you can move and deposit funds in accounts.

Make it as complex as you want to learn, try to change the behavior of this application by using different ways to do the same thing.

After some more of this recording and tinkering, you will need some more recording and tinkering and then some less recording and more writing, but the tinkering will be constant or increase with the days.

Good luck. Oh and take a picture of yourself NOW . You will need it for moral support when your application stops working for some reason…

Wassim in the

Reply | Quote

I agree with the rest of the folk here – do a course if you get a chance. VBA is a complex enough language that you really need a structured, live course where you can focus on that subject and nothing else for a few days. Doing it from a book or video or on your own, there will be constant interuptions, and you tend to go in great depth in a few places and never get a good overall view of the scope. In any event after doing a course, you will find the books of much greater value. One significant point too is that you can’t record macros in Access in the same fasion as you do with Excel or Word. And code done with recording usually has to be modified to work in a more general environment. You have lots of fun ahead!

Reply | Quote

Cheers Guys,

An expensive course it is.

Can anyone actually recommend a good company. I’m sure there’s loads out there. It would probably have to be in London and judging by your profiles I don’t expect Wendell, Legare or Wassim to be able to help
Wassim – off topic – I went to a VERY nice club in NY once called the “VIP club” – amazing what $20 can get you.

Anyway, thanks people!
John

Reply | Quote

This is nowhere near as specific as I’d like, however……… When I was in the UK, attended a fair number of MSDN events. One of their main (& best) 3rd party sources of lecturers was a company that was based in Basingstoke, and had (I believe) the initials ICS. They all certainly tended to know what they were talking about and co-sponsored a Visual Studio 6 conference for example. Maybe you’ll have some luck witnh a UK-based search engine, but a few searches have yet to turn them up. HTH

Reply | Quote

You can learn Office VBA a lot cheaper than that if you are not averse to learning online with a remote tutor available for assessment and assistance.
The course I have in mind is “Programming in Visual Basic” which is project based (8 in Total) and covers both VB and VBA also has additional miniprojects in excel etc. Cost

Reply | Quote