VBA/C++ Interfacing with Excel

Course materials

VBA resources

• Plotting Routines (xls)
• Examples (xls)
• Examples on errors (xls)
• Coursework (pdf)
• Notes (pdf)

C++ resources

• How to get started with Visual Studio
• Notes (pdf)
• Last Years Examples (pdf)

C++ Coursework

• Coursework 2 - Quadrature (pdf)
• Coursework 3 - SDEs (pdf)

C++ Lecture 1

• Lecture - Introduction (pdf)
• Examples Sheet 1 (pdf)
• Solutions Sheet 1 (pdf)
• Debugging programs
• Syntax check list
• Writing to file

C++ Lecture 2

• Lecture - Functions (pdf)
• Examples Sheet 2 (pdf)
• Example codes

C++ Lecture 3

• Lecture - Classes (pdf)
• Examples Sheet 3 (pdf)
• Example codes

C++ Lecture 4

• Lecture - Inheritance (pdf)
• Examples Sheet 4 (pdf)
• MTRand class - how to...

C++ Lecture 5

• Refer to the notes on how to include your codes in Excel.
• Examples Sheet 5 (pdf)

C++ Review: Bank Class

• Lecture - Inheritance (pdf)
• Code listings

Useful links

• C++ resources network
• C++ Programming
• Fredosaurus
• A C++ short course

Reading List

• D. Alcock, "Illustrating C", Cambridge University Press, 1992.
• D. Yang, "C++ and object-oriented numeric computing for scientists and engineers", Springer, 2000.
• S. Meyers, "Effective C++: 55 specific ways to improve your programs and designs", Addison-Wesley, 2005.
• M. McGrath, "C++ Programming in easy steps", 2002, Computer Step.