Modeling for application: developing industrial strength simulation models using Visual Basic for Applications (VBA)

@inproceedings{Seppanen2000ModelingFA,
  title={Modeling for application: developing industrial strength simulation models using Visual Basic for Applications (VBA)},
  author={Marvin S. Seppanen},
  booktitle={Winter Simulation Conference},
  year={2000}
}
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… CONTINUE READING

Citations

Publications citing this paper.
Showing 1-10 of 10 extracted citations

Similar Papers

Loading similar papers…