Excel® Programming: Your visual blueprint™ for creating interactive spreadsheets

Appendix A. VBA Quick Reference

VBA and Excel Object Model Quick Reference

VBA Statements Quick Reference

Legend:

Plain courier text = required  [] = optional             | = or

Italics = user-defined               ... = list of items

File and Folder Handling

STATEMENT	DESCRIPTION
ChDir path	Changes to the specified folder location.
ChDrive drive	Changes to the specified drive.
Close [filenumber]	Closes a file opened by using an Open statement.
FileCopy source, destination	Copies a file from the source to the specified destination.
FreeFile[(rangenumber)]	Each open file is represented by an integer value. Returns the next available integer value for use by the Open statement.
Kill pathname	Deletes files from a disk. Use wildcards (*) for multiple characters and ...