Stephan Mccarthy

Access Visual Basic and Excel VBA Macros - A Comparison of the MS Office Programming Languages

- variables (the DIM statement)- IF conditions and loops- message boxes and input boxes- subroutines and functionsIf that didn't make much sense, worry not - the rest of this article will explain each of these points in turn.Access has Two Macro Languages... Read >

Microsoft Excel Event-Driven Programming - How to Attach a Macro to the Event of Opening a Workbook

I don't think I have a perfect answer for this, this is what I think.Firstly, it is seldom good idea to pick up a book on Excel programming and start reading it from cover to cover. It is better to learn when there is a specific task at hand. Excel's macr... Read >