Re: macro definition in Ms office?
A macro is a script that is either written or recorded in Visual Basic for Applications. It is often used for organization of data or for things that are repeated often. It is very versatile and can link multiple programs or databases together.
Things I've used Macros for:
Getting rid of unnecessary data
Sorting data a certain way
Duplicating or naming a large number of worksheets
Making forms for people to fill out
Custom password protect of excel files
Grabbing data from Access or SQL databases
Emailing excel data through Outlook
Running things at certain times of the day
You can do just about anything you want to imagine with it. It is capable of using other programming languages as well, such as WSH or strict VB.
Hope this helps,
Robert D. Specian Jr.
A macro is a script that is either written or recorded in Visual Basic for Applications. It is often used for organization of data or for things that are repeated often. It is very versatile and can link multiple programs or databases together.
Things I've used Macros for:
Getting rid of unnecessary data
Sorting data a certain way
Duplicating or naming a large number of worksheets
Making forms for people to fill out
Custom password protect of excel files
Grabbing data from Access or SQL databases
Emailing excel data through Outlook
Running things at certain times of the day
You can do just about anything you want to imagine with it. It is capable of using other programming languages as well, such as WSH or strict VB.
Hope this helps,
Robert D. Specian Jr.
