Developing industrial strength simulation models using Visual Basic for Applications (VBA)
Developing industrial strength simulation models using Visual Basic for Applications (VBA)
复制标题
使用 Visual Basic for Applications (VBA) 开发工业强度仿真模型
DOI：
10.1109/wsc.2000.899701
复制
发表时间：
2000
期刊：
影响因子：
--
通讯作者：
Marvin S. Seppanen
中科院分区：
文献类型：
--
作者：
Marvin S. Seppanen
自1984年以来，作者一直在开发使用电子表格输入数据的模拟模型。这些原始应用程序使用独立的BASIC程序将Lotus123(R)数据转换为SIMAN实验框。虽然这一过程经过了一段时间的发展，但直到Arena(R)3.0推出Microsoft(R)的Visual Basic(R)for Applications(VBA)，它才达到真正可行的水平。本高级教程演示了作者开发的在Excel(R)和Arena之间传输数据的基本概念。同样的技术可用于与多种支持VBA的工具，如Access(R)、AUTOCAD(R)和Visio(R)进行模拟数据通信。Arena允许模型开发人员在加载、执行或终止模型文件时使用VBA，或者在实体流经Arena模型模块时使用VBA。本文的重点是为仿真应用程序设计Excel工作簿，以及使用VBA与Arena之间的数据传输。
Since 1984 the author has been developing simulation models that use input data from spreadsheets. These original applications used a standalone Basic program to convert Lotus 123(R) data into Siman Experiment Frames. While this process has evolved overtime, it did not reach a truly viable level until Arena(R) 3.0 introduced Visual Basic(R) for Applications (VBA) by Microsoft(R). This advanced tutorial demonstrates the basic concepts developed by the author to transfer data between Excel(R) and Arena. The same techniques can be used to communicate simulation data with a wide range of VBA supported tools, such as Access(R), AutoCAD(R) and Visio(R). Arena permits the model developer to use VBA as the model file is loaded, executed, or terminated or as entities flow through the Arena model modules. The article focuses on the design of Excel workbooks for simulation applications and the transfer of data to/from Arena using VBA.