Lynda com Excel VBA in Depth 英文正式版 (教學)





軟體簡介:



LyndacomExcelVBAinDepth英文正式版(教學)







語言：英語
網址：http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906
類別：教學

Lynda.com出品的長達3小時視頻教學中CurtFrye講解了為如何使用VBA的面向物件編程技術自動完成
excel工作和提高excel工作效率。



InExcel:VBAinDepth,ExcelandVBAexpertCurtFrye
introducesobject-orientedprogrammingandshowshowto
automateroutinetasksandprovidecustomfunctionality
toenhanceExcelperformanceandefficiency.Thiscourse
introducestheVisualBasicforApplicationsprogramming
language,coverscreatingsubroutinesandfunctionsto
holdcode,andprovidesasolidgroundingintheExcel
2007objectmodel.Programmingtechniquesaredemonstrated
throughreal-worldexamples.Exercisefilesaccompanythe
course.

Topicsinclude:

*WorkingintheVisualBasicEditor
*Addingcodetoamacro
*Creating,exporting,anddeletingcodemodules
*Declaringandusingvariables
*Managingvariablescope
*Definingarrays
*ManagingworkbooksandworksheetswithVBA
*Repeatingtaskswithloops
*DebuggingVBAcode
*Cutting,copying,andpastingcelldata
*Runningandtriggeringeventprocedures