Week 4
How is a macro utilized within Microsoft® Excel®?
Macro is designed for the do-it-yourselfer. The software program is ranked among the most useful tools of Microsoft programs. They took a task that would have been executed manually and made it automatic for many computer tasks. This can be from a simple task of creating spreadsheets or worksheets to a very complex task of exporting journal entries in an Excel program into an accounting package and the creating reports in Word. What makes Macros so great tis that in a lot of cases you don’t need to be an expert to set it up? You need to invest a little of time to learn the language they are written it
.
Name various business functions that require the use of a macro.
One of the biggest business functions that may require the use of a Macro program would have to be making spread sheets for accounting firms. By making spread sheet it would make it easier for CPA’S to do taxes at the end of the year. You can run Quires or spread sheets which can help with just about and field.
What are possible limitations using macros within Microsoft® Excel® and how would you convey this to a user?
Character limitations and Macro Security
If these limitations are exceeded, you may receive run-time errors in your Automation code
I would tell the user that there are limitations when using macro so they should read over the instruction to see what all of the limitation are before they start using
Macro is designed for the do-it-yourselfer. The software program is ranked among the most useful tools of Microsoft programs. They took a task that would have been executed manually and made it automatic for many computer tasks. This can be from a simple task of creating spreadsheets or worksheets to a very complex task of exporting journal entries in an Excel program into an accounting package and the creating reports in Word. What makes Macros so great tis that in a lot of cases you don’t need to be an expert to set it up? You need to invest a little of time to learn the language they are written it
.
Name various business functions that require the use of a macro.
One of the biggest business functions that may require the use of a Macro program would have to be making spread sheets for accounting firms. By making spread sheet it would make it easier for CPA’S to do taxes at the end of the year. You can run Quires or spread sheets which can help with just about and field.
What are possible limitations using macros within Microsoft® Excel® and how would you convey this to a user?
Character limitations and Macro Security
If these limitations are exceeded, you may receive run-time errors in your Automation code
I would tell the user that there are limitations when using macro so they should read over the instruction to see what all of the limitation are before they start using