Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

word macros

ResolvedVersion 2007

Victoria has attended:
Excel Advanced course

Word Macros

What is a Macro and when would I used them?

RE: Word Macros

Hi Victoria

Thanks for your question. A macro is an automated sequence of instructions. Macros can be recorded and played back by the click of a button.

More complex macros can be written in Excel, Word or other Office Applications that can greatly speed up a process that may be time consuming and repetative.

Fro example, of Word macros might be recorded to open a letter template or a standard header text.

A written maco in Word could be one to create a form with multiple choice questions. With Excel a macro could be written to produce and format a report from a table of data.

We run courses usually for Excel to learn the programming language called Visual Basic for Applications (VBA) used for writing macros.

I hope that helps.

Doug
Best STL

Mon 23 Jun 2014: Automatically marked as resolved.

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.