Developing Microsoft Excel 95 solutions with Visual Basic for applications (2nd ed.): development strategies using the Microsoft Excel for Windows 95 object model and VBA
Developing industrial strength simulation models
WSC '95 Proceedings of the 27th conference on Winter simulation
VB and VBA in a nutshell: the language
VB and VBA in a nutshell: the language
VBA Developer's Handbook
Designing Simulation Models to Use Visual Basic® for Applications (VBA)
Proceedings of the 12th European Simulation Multiconference on Simulation - Past, Present and Future
CEPM 1: simulation modeling and optimization of stockyard layouts for precast concrete products
Proceedings of the 34th conference on Winter simulation: exploring new frontiers
Operator-paced assembly line simulation
WSC '05 Proceedings of the 37th conference on Winter simulation
Flexible module-based modeling and analysis for large-scale transportation-inventory systems
WSC '05 Proceedings of the 37th conference on Winter simulation
Impacts of radio-identification on cryo-conservation centers through simulation
Winter Simulation Conference
Impacts of radio-identification on cryo-conservation centers
ACM Transactions on Modeling and Computer Simulation (TOMACS)
| Hi-index | 0.00 |
Since 1984 the author has developed simulation models that use input data from spreadsheets. These original applications used a standalone Basic program to convert Lotus 123® data into Siman Experiment Frames. While this process has evolved overtime, it did not reach a truly viable level until Arena® 3.0 introduced Visual Basic® for Applications (VBA) by Microsoft®. This advanced tutorial demonstrates the basic concepts developed by the author to transfer data between Excel® and Arena. The same techniques can be used to communicate simulation data with a wide range of VBA supported tools, such as Access®, AutoCAD®, and Visio®. 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. This tutorial focuses on the design of Excel workbooks for simulation applications and the transfer of data to/from Arena using VBA.