 If
your need is to import or manipulate data in Excel then
this is the menu to do it. From here you can set imports
from text files, external databases and web sites, built
pivot tables and if you have Excel 2003 build 'lists'
or, if you have Office Professional enjoy the XML
features that Excel 2003 offers.Excel versions from
97 also give you the option here to validate user entry
via Data Validation...
As a rule in Office, (and most windows), programs, any
menu options with three ellipses (...) after the menu
option, will be followed by another dialog, any options
with a
►, will be followed by a sub-menu if
you hover over the
►.
The menu options on
the image to the left are live hyperlinks and will help
you navigate to the relevant page or you can use the
links on the far left.
In the linked pages you will find
detailed explanations of the option, together with a
code snippet on how the menu option may be implemented
in VBA (Visual Basic for Applications), any lines in
these snippets starting with a single apostrophe(') are comment lines to assist you
and explain what is being done and if pasted into
a module will appear green with no notice being taken of
them when the code is run. (To
implement and explain
VBA you would do best to read
the pages on this subject first).
Top |
