Office 應用程式如 Excel 等都含有 Visual Basic for Applications (VBA),它是一種程式語言,能讓您具有擴充應用程式的能力。
VBA 以執行「巨集」的方式運作。而所謂的巨集就是使用 Visual Basic 語言撰寫之循序漸進的步驟流程。學習撰寫程式聽起來好像很難,但只要有耐心再配合一些範例 (像是本文中所提供之範例),許多使用者都會發現,即使只學會一點點 VBA 程式碼,都對他們的工作有莫大的助益,讓他們可以在 Office 內達成之前做不到的事。只要您學會一部分的 VBA,要學會其他的就簡單多了。所以之前的不可能的現在都變成可能了。
1.課程設計的全方位內容,主題涵蓋完整,包括在電腦和行動裝置上執行的應用軟體、app、作業系統、公用程式,還有網際網路、全球資訊網與雲端運算的介紹。
2.Excel VBA
3.MS OFFICE課程設計的全方位內容
4.Excel VBA
5.MS OFFICE
透過實作,學生能奠定紮實的電腦知識,更懂得如何運用電腦和善用全球資訊網,了解科技趨勢發展並建立宏觀的想法。Office applications such as Excel contain Visual Basic for Applications (VBA), a programming language that gives you the ability to expand your application.
VBA operates in the form of "macross". And the so-called giant collection is a step-by-step process of writing in Visual Basic language. Learning to write a program seems difficult to hear, but as long as you are patient and cooperate with some examples (such as the ones provided in this article), many users will find that even if you only learn a little VBA program, it will be of great help to their work and allow them to accomplish things they cannot do before in Office. As long as you learn some VBA, it is much easier to learn others. So the impossible before has become possible now.
1. The course design has a comprehensive content and the theme covers the complete theme, including application software, apps, operating systems, and utilities executed on computers and mobile devices, as well as introductions to Internet, global information networks and cloud computing.
2. Excel VBA
3. All-round content of MS OFFICE course design
4. Excel VBA
5.MS OFFICE
Through practice, students can lay down practical computer knowledge, know how to use computers and make good use of global information networks, understand the development of technological trends and build macro ideas.
1.講義
2.跟我學Excel VBA:將複雜的操作用一個按鍵就搞定!
作者:江高舉
出版社:碁峰
語言:繁體中文 ISBN:9789862760352
裝訂:平裝
1. Lecture
2. Learn Excel VBA with me: Use one button to complete the complex operation!
Author: Jiang Gaoyou
Publisher: Qi Feng
Language: Traditional Chinese ISBN: 9789862760352
Decoration: Flat
評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
---|---|---|
作業與專題作業與專題 Business and topics |
40 | |
期中考期中考 Midterm exam |
30 | |
期末考與期末分組專題期末考與期末分組專題 Final exam and final division topics |
30 |