_ExcelScripting_1up - CS 200 Lecture 07 Excel Scripting CS 200 Spring 2014 Wednesday 1 Excel Scripting Miscellaneous Notes Abbreviations aka Also Known

_ExcelScripting_1up - CS 200 Lecture 07 Excel Scripting CS...

This preview shows page 1 - 7 out of 50 pages.

CS 200CS 200 Spring 2014Excel Scripting1Lecture 07Excel ScriptingWednesday, June 18, 2014
Background image
CS 200 Spring 2014Excel 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, © 20022Wednesday, June 18, 2014
Background image
CS 200 Spring 2014Excel 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 Read and Reason PearlRemember that the CWS contains material on the pearls WarningWe are running Oce 2011, in the Mac Labs—test Windows docs in the lab before submitting3Wednesday, June 18, 2014
Background image
CS 200 Spring 2014Excel 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 similar4TWednesday, June 18, 2014
Background image
CS 200 Spring 2014Excel 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 similar4TWednesday, June 18, 2014
Background image
CS 200 Spring 2014Excel ScriptingApplication Scripting in ExcelWhat is “(intra-)application scripting”?
Background image
Image of page 7

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture