Excel VBA Financial Management Application Case Analysis

Author: Han Liangzhi
Publisher:
Publish Date: 2006-01-01
Features: This book uses Excel VBA as the development platform and takes an example of a practical financial management system to demonstrate how to develop a financial management system using Excel VBA, ADO database access technology, and SQL language. The financial management system provided in this book can be easily ported and applied to enterprise financial management. The content covers several aspects, including overall system design, system functional design, user interface design, report design, programming, data storage, and backup. It encompasses the main daily financial management tasks, from entering daily accounting data to summarizing and analyzing accounting data, and finally to preparing accounting reports. This book is suitable for managers and financial personnel in enterprises and institutions, particularly for those who are developing company financial management application systems. It can also serve as a textbook or reference book for undergraduate, graduate, and MBA students in economics at universities and colleges.