excel courses - How to record / run a macro

The UK's most regular instructor-led training courses.
Training information: excel courses · Excel courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

How to record / run a macro

paul has attended:
No courses

by - delegate paul [1 post] (2007 Jun 28 Thu, 13:30) Reply

how to record / run a macro

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: how to record / run a macro

by - trainer Tracy platinum contributer [586 posts] (2007 Jun 29 Fri, 14:40) Reply

Hi Paul,

If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored and can be run whenever you need to perform the task.

For example, if there is a seris of calculations or formatting that are regularly carried out manually this could be automated as a macro

When you record a macro, Excel stores information about each step you take as you perform a series of commands. You then run the macro to repeat, or "play back," the commands.

Macros are created from the Tools > Macros > Macro menu options

Hope this helps

· Tips to Facilitate Printing of Excel worksheets
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Microsoft Excel Training: Not Just for Newbies Anymore
· A Beginners Guide To Formulas In Excel

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips