General discussion

Locked

Excel & Access Macros

By Birdieboy ·
I am keen to find examples/ideas of how to use macros Excel and Access. Anyone got any urls or deecnt books (not programming in VBA specific).

Thank you
John

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel & Access Macros

by deancutting In reply to Excel & Access Macros

Using wwww.google.com to search for "excel macros" I was able to find severel useful excel tutorials and even a statistician who published

A worksheet for calculating the Mantel-Haenszel estimate of the common risk ratio from stratified 2 by 2 tables and a test of homogeneity of the stratum-specific risk ratios.

http://www.pauldickman.com/teaching/excel.html

Now there's an example for ya!

Also came across http://www.oreilly.com/catalog/exlmacro/

? your comment "not programming in VBA specific" -- is puzzling. It's hard to get one without the other! They are one and the same.

The way I got started with Excel macros, was to turn on the macro recorder to do something. When you go back and edit the "macro" this takes you in to Excel's Visual Basic editor, where you can examine and modify the VBA code that Excel created during the recording session. You can find out some very interesting features that way. Unfortunately, the barrier to entry to program is to learn VBA.

HTH

Collapse -

Excel & Access Macros

by Birdieboy In reply to Excel & Access Macros

The question was auto-closed by TechRepublic

Collapse -

Excel & Access Macros

by Limbo In reply to Excel & Access Macros

Interesting examples.

Classically, Macros were created to automate repetitive tasks within programs like text editors.

Now, a Macro within the context of VBA development, can extend a whole host of services across multiple applications.

Keeping in mind these two principles, it is true that you can create Macros without ever entering a single line of code.

However, it is in the understanding of the term 'repetitive task' where most people over stretch themselves.

Most tasks are NOT repetitive. So a Macro created without VBA 'tampering' may automate on one particular type of document with the desired results.

Change the format of the document ever so slightly, and the automation may not work as expected (if at all).

Itis frustrating to say the least. And as a consequence many find learning VBA is the only way to get the flexibility desired.

In fact if you've ever had any programming experience at all, It may prove to be the lesser of two evils to master VBA for this purpose alone.

Still, I will readily admit that impressive results can be gained with insightful uses of Macros.

Best of luck in your research John.

Limbo

Collapse -

Excel & Access Macros

by Birdieboy In reply to Excel & Access Macros

The question was auto-closed by TechRepublic

Collapse -

Excel & Access Macros

by Birdieboy In reply to Excel & Access Macros

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums