vba courses london - Excel, Access, VBA

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Excel, Access, VBA

Robert has attended:
Excel VBA course

by - delegate Robert [2 posts] (2006 Dec 20 Wed, 13:33) Reply

The VBA code that i write for excel; is it the same code i would use for the microsoft application Access?

Regards

Rob Brown

RE: Excel, Access, VBA

by - trainer David gold contributer [428 posts] (2006 Dec 20 Wed, 14:36) Reply

Hi Robert

You will find that the code syntax itself it pretty much identical, however excel and access have different functions so you will not be able to apply the code exactly as you learnt it for excel into a access vba, they are however very similar. If you want to learn access vba code I do suggest that you attend an access vba course. As this will enable you to code access vba much faster.

But essentially the code syntax is the same, just with functionality differences ie the same functions that are available in excel may not be there in access or they may have different names etc

Hope this helps

David

RE: Excel, Access, VBA

by - delegate Robert [2 posts] (2006 Dec 20 Wed, 16:52) Reply

David,

THanks

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Should You Send Managers To VBA Training?
· Introduction to Visual Basic for Applications
· How To Find A Good VB For Access Trainer
· Company Roles in Visual Basic Training

Vba tip:

Add A New Sheet at the end of the Workbook

To add a new sheet at the end of the workbook you need to count the sheets in the workbook using:

Sheets.Count

Then use this value as the rank of the sheet after which you want to add the new sheet:

Sheets.Add After:=Sheets(Sheets.Count)

View all VBA hints and tips