1 / 10

MGMI 311 Computer Programming

This course assessment provides an overview of the fundamental concepts in VBA (Visual Basic for Applications) programming. Key topics include the structure and declaration of variables and constants, their initialization and scopes, as well as reserved words specific to programming. Additionally, the importance of comments in code clarity is emphasized. By learning to utilize VBA, participants will be equipped to develop applications that enhance Microsoft Office functionality, particularly for creating Decision Support Systems (DSS) in Excel. Collaborate in teams to explore business processes and programming basics.

wanda
Télécharger la présentation

MGMI 311 Computer Programming

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MGMI 311 Computer Programming

  2. Course Assessment

  3. Program Structure • Declaration – Variables and Constants ต้องบอกก่อน • Initiation and Scopes ค่าเริ่มต้นของแต่ล่ะตัวแปร • Reserved Words ศัพท์เฉพาะของแต่ละตัวแปร • Comments คอมเม้นท์เป็นภาษาคน บางอันใช้ไฮเฟ้น ช่วยให้เราอ่านโปรแกรมรู้เรื่อง • Instructions ตัวโค้ดดิ้ง

  4. VBA • VBA = Visual Basic for Applications • Is it the same as VB ( Visual Basics) ?? • VB = programming language developed by Microsoft • VBA = tool that is used to develop programs that control Microsoft Office Application i.e. Excel, Access or Word

  5. Why VBA ? • VBA is becoming the programming language of choice for an increasing wide range of application developers ต่อยอดพื้นฐาน Excel • In many companies, programmers provide applications called ‘Decision Support Systems (DSSs)’ – These are applications based on Excel or some other packages

  6. Why VBA ? • VBA is a relatively easy programming language to master • This makes it accessible to a large number of nonprofessional programmers in the business world

  7. VBA Concepts Object • Properties • Value • Methods • Arguments

  8. Object Vs Parts of Speech • Object = Noun คำนาม • Properties = Adjective คำขยายคำนาม คุณสมบัติ • Methods = Verb กริยา ตัวที่บอกว่าให้คอมทำอะไร • Argument = Adverb ตัวขยาย Methods • สมมติว่าไป แล้วไปที่ไหน ไปที่ไหนคือขยายกริยาว่าไปที่ไหน • Adverb = ไปที่ไหน

  9. VBE – Visual Basic Editor • Alt – F11 : to access Visual Basic Editor • Toolbar • Standard Toolbar • Edit Toolbar • Debug Toolbar

  10. Week01 Assignment • Form a group of 3-4 persons • Think of a Business of Interest • Define the Business Processes • Discussion board on http://mgmi.wikispaces.com/MGMI311

More Related