Visual Basic Info

[Dasher]

Hello, could someone please point me in the right direction? I often use Microsoft Access and to a lesser degree, Microsoft Excel. I need to learn more about writing code and am unsure as to whether I can do a course that would be applicable to both Access & Excel (would this be a Visual Basics for Applications course?) or just a Visual Basics for Access course?

Thanks for your help

[debasisdas]

What are you doing with access and excel ? Writing any macros ?

[daniel aristidou]

I think your looking for a VBA course......
VBA Should work for both access and Excel..
My advice is to ask the teachers...

[Dasher]

Thanks for the replies.

I have been using macros in Access ut hav reached a point were i need to use and read other peoples code.
Work has offered to put me on courses and this is were im a little confused about VBA/VB.

So from the above post I assume VBA will apply to Access and Excell.

So if im going to put in the time learning code am I better of looking at specific course on Access or learn something that I may be able to apply to other programs/situations i.e. VBA ?

Does that make sense?

[Killer42]

I don't know about the courses. But one way to pick up VBA in Excel is to record macros. Then you can edit them, and the code is there, already written for you. It's a fairly quick and easy way to learn how to perform specific tasks in VBA, and how the code fits together.

[WinblowsME]

My suggestion is to pick up a VB 6.0 book, or enroll in a VB 6.0 course (if they're still around). Then, migrate to VBA. Like Killer mentioned, Excel's Macro Recorder is a fast way to learn VBA, even faster if you know VB 6.0.