應用Excel VBA開發 簡易購物車(Shopping Cart)系統

Abstract

摘要 因應國內新型冠狀病毒肺炎疫情嚴峻，政府規定了店家內的人數限制，為了減少人群的接觸，大部分的店家採取線上訂購的方法促進消費者方便採購，又能避免疫情的擴散，故在這次的報告裡參考了網路上購買商品的網站，結合了工程資訊管理課程所學的VBA程式設計了一套線上訂購賣場商品的購物車簡易操作平台。 參考並研究範本的基本功能，加以改善其缺點，透過了模仿學習了如何寫VBA程式碼的邏輯跟方法，並新增一些額外購物車的訂購功能，以便消費者使用。 經過了此次報告，更清楚寫程式都是從模仿開始，先了解他人寫程式所會使用的邏輯，在內化後重新寫成自己一套的程式，但都是執行一樣的功能，或者是一樣的功能可以套用在不同目的的操作上。

Abstract Due to the severe domestic COVID-19 epidemic, the government has placed restrictions on stores to maintain the number of people. In order to implement social distance , more stores have taken online ordering methods to facilitate consumers purchase and avoid the spread of the epidemic. As a result , referring to the website for purchasing goods on the Internet and combining with the VBA program learned in the engineering information management course, to design a simple operation platform like shopping carts for online shopping commodities in the store. Not only referring to and studying the basic functions of the example ,but also improving its shortcomings and learning the logic and methods of how to write VBA code through imitation. Besides , adding some additional shopping cart ordering functions for consumers to use. After this report, it is clearer that writing programs starts with imitation. First , understanding the logic used by others to write programs, and rewrite their own programs after internalization, but they all perform the same function. Also , the function can be applied to operations for different purposes.