|
Before
you Go.. |
- Join
our mailing list.
It's
free and only goes out once per
month. It's packed with valuable Excel
related info, tips and ideas you'll really use!!
- Ensure
you don't forget this site! Bookmark this page for
future reference.
|
|
|
|
Microsoft
Excel
Help and
Information Center |
| VB
CODE and MACROS |
Visual
basic macros, whether they are recorded or custom written, are
powerful tools that can save you an immense amount of time by
automating tasks within Microsoft Excel.
Please view the information to the right for some basic
guidelines. Below are some links to companies and individuals
who can write applications for you:
Aurora
Business Applications
Contact: Tim
Holmes, 905-356-8697
Description: Aurora Business
Applications can design a solution for your business, no
matter what the application. Aurora has been writing visual basic
applications in Excel for years, for clients all over the US
and Canada.
|
|
.
. . . . . . .
. . . . . . .
. . . . . . . . |
Please let
us know what you think of this site, and what should be
done to improve it.
This site is not affiliated
with Microsoft Corporation.
(c) Aurora Internet
Enterprises. |
|
|
|
Some Basic Guidelines: |
(1)
You can assign a macro to do almost any repetitive task such
as inserting text or values, opening files, etc. These macros
can be assigned to a button or link for easier activation.
(2) To make a recorded
macro run relative to your cell location, turn on the USE
RELATIVE REFERENCES option when recording. You can do
this by clicking on the icon that looks like a cell grid in
the Record Macro toolbar.
(3) To make a macro do incremental
tasks or decisions based on data in the spreadsheet or user
input, you will have to create a custom written macro
that requires some basic VB programming knowledge. |
|
|
Always
Remember...
If you expect to use a macro in different versions of Excel, in most
cases it is better to record or write that macro while in the OLDEST
version. This will better ensure compatibility in all versions. |
|
|
 |
|