By Topic

Developing industrial strength simulation models using Visual Basic for Applications (VBA)

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$33 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

1 Author(s)
M. S. Seppanen ; Productive Syst., Winona, MN, USA

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

Published in:

Simulation Conference, 2000. Proceedings. Winter  (Volume:1 )

Date of Conference:

2000