CS 200CS 200 Fall 2012Excel Scripting1Lecture 06Excel ScriptingFriday, October 12, 2012
CS 200 Fall 2012Excel ScriptingMiscellaneous NotesAbbreviationsaka Also Known AsCWS Course Web Site ()VBE Visual Basic Editorintra- a prefix meaning within — thus “intra-cellular” means “within the cell”inter- a prefix meaning between — thus “inter-galactic” means “between galaxies”For our purposes, a “macro” and a “script” are the same thingOptional background readingWriting Excel Macros, Chapters 3 and 4, (in library)Excel Review (Learn)Excel Review Exercises (Learn)A good reference if you’re interested in learning more about Excel Scripting isWriting Excel Macros (2/e), by Steven RomanO’Reilly & Associates, ISBN 0-596-00359-5, © 20022Friday, October 12, 2012
CS 200 Fall 2012Excel ScriptingAdministriviaPlease read and highlight the assignment and course notes before labStaffsuggests reading the assignment before lecture(Last term’s is usually quite similar to this term’s, if the latter is not yet available)There are hyper-text commented source files for most of the Excel macros used in this lecturesee “Lectures > Commented Excel Macros” on the CWSFiles used in this lecture are inCS 200 / cs200 Public / Files for Excel Scripting / LectureTodayScripting in ExcelThe Toy PearlRemember that the CWS contains material on the pearls WarningWe are running Office 2011, in the Mac Labs—test Windows docs in the lab before submitting3Friday, October 12, 2012
CS 200 Fall 2012Excel ScriptingApplication Scripting in ExcelWhat is “(intra-)application scripting”?a way to automate lengthy manual proceduresa way to customize / extend an applicationa way to create a different interface“programming in the small”Recording a script“record” a manual procedure (once)and “play it back” many timessort of like a player pianorecord a script to learn how to do somethinglook up terms in the script as necessary“anything you can do manually, you can script” — & moreEdit a recorded scriptto make it more generalto eliminate unnecessary stepsto wrap a loop around itto do something similar4TFriday, October 12, 2012
CS 200 Fall 2012Excel ScriptingApplication Scripting in ExcelWhat is “(intra-)application scripting”?a way to automate lengthy manual proceduresa way to customize / extend an applicationa way to create a different interface“programming in the small”Recording a script“record” a manual procedure (once)and “play it back” many timessort of like a player pianorecord a script to learn how to do somethinglook up terms in the script as necessary“anything you can do manually, you can script” — & moreEdit a recorded scriptto make it more generalto eliminate unnecessary stepsto wrap a loop around itto do something similar4TFriday, October 12, 2012
CS 200 Fall 2012Excel ScriptingApplication Scripting in ExcelWhat is “(intra-)application scripting”?
You've reached the end of your free preview.
Want to read all 49 pages?
- Fall '13
- LiBin
- Visual Basic for Applications, scripting language, scripting
