Databases Reference
In-Depth Information
To delete the columns first discussed, the following two calls to the
DeleteColumnX
sub-
routine would have to be made.
Call DeleteColumnX("ELDReport.xls",1,"ReRun",5)
Call DeleteColumnX("ELDReport.xls",1,"Position",6)
1.11
SUMMARY
To utilize and manipulate information in Excel in any meaningful manner, a developer must know
how to access the data contained within its Worksheets. As such, the programmer must have the
fundamental skills required to access data contained within different Workbook/Worksheet pairs.
The idiosyncrasies of accessing data using explicit referencing are discussed, as well as the methods
of searching for data required to automate a particular task. The methods of copying, clearing, and
deleting data from Worksheets are discussed, as well as the fundamental methods of deleting row
and columnar data. With mastery of these basic skills, the reader is ready to proceed into more
specialized topics.
