Kirch Trim Loss and Inventory Optimisation in Paper Mills Qi-Shan Lim Optimisation Models and Methods for the Container Positioning Problem in Port Terminals A. Session Th2: Young Practitioners Prize Session #2 (C2 13:30-15:10) Capacity Planning For Process Industries James O.
Engineer Making Smarter Transportation Investments Kane Harton A Rostering Integer Programming Model for Ambulance Staffing Karl Ho Optimisation of Mould Filling Parameters during Compression Resin Transfer Moulding Process Wing Ki Kam Session Th1: Young Practitioners Prize Session #1 (C2 10:50-12:30) Faster Ambulance Simulation Runs using Artificial Call Sampling Eduard Bulog Catch-up Scheduling for Childhood Vaccination Faramroze G. Norske Skog Improves Global Profitability Using O.R. Table of Contents Thursday Thursday Keynote Presentation (ThK): (C2 9:35–10:20) Graeme Everett, Rune Gjessing, Kjetil Vatn, Andy Philpott The conference could not have been possible without the invaluable assistance of the Conference Committee: Shane Dye (Chair) Pavel Catska John George (YPP Coordinator) John Giffin Terri Green Ross James Don McNickle Nicola Petty John (Fritz) Raffensperger E. The Conference Committee would like to thank the sponsors IBM ILOG, Univeristy of Canterbury, Paragon Decision Technology, and Hoare Research Software. As chair of the Conference committee it is a pleasure to see such a strong collection of papers and, especially, such a large group of students attending and presenting papers. Preface The papers in this volume form the Proceedings of ORSNZ09, the 44th Annual Conference of the Operational Research Society of New Zealand (ORSNZ), held December 3 to 4 at the University of Canterbury, Christchurch New Zealand. SPONSORS We are most grateful for the financial support we have received from IBM ILOG, University of Canterbury, Paragon Decision Technology and Hoare Research Software. ORSNZ 09 December 3 – 4th 2009 University of Canterbury Christchurch New Zealand
Operations Research Society of New Zealand Proceedings of the 44th Annual Conference Wb = (xl.Workbooks.Open(fileName, Missing. Yes, the xlam is the extension for addins in Excel 2007. I was given the same error by the solver when I tried to do so. My original intent was to launch an Excel Workbook from within Microsoft Access and automatically run the Excel solver with the data exported from Access (since Access does not have the solver feature).
But when I try to run Macro2 inside "Book2.xls" (either through "Tools\Macro\Macros.\Macro1 -> Run " or in the VB editor), the Solver gives me an error "Solver: An unexpected internal error occurred, or available memory was exhausted".ĭoes someone have any idea of how to fix this problem? With this code, I can open "Test.xls" manually, which then automatically opens "Book2.xls". Workbooks.Open Filename:="C:\test\Book2.xls" I then created another workbook named "Test.xls" with the following code. Macro1 runs fine if I open "Book2.xls" manually and either run it through "Tools\Macro\Macros.\Macro1 -> Run " or run it in the VB editor. I have the following micro in a workbook named "Book2.xls": I have a problem with programming Excel solver using vba.