If you are a ‘recursion newbie’, you may want to first read Getting started with recursion, or take a look at a real, but simple example with How to traverse a treeview
Getting to grips with recursion
Recursion Introduction – that most elusive of techniques. 2 challenge projects developed as we go along.
- Roadmap Generation: For intermediate skills upwards.A project to create a dynamic roadmap generator, to illustrate the use of classes, recursion and excel Shape manipulation. You might want to first read the sections on classes and data manipulation.
- Assigning Parents and Children – How to create a parent / child relationships
- Getting Roadmap Parameters – How to use parameter sheets to communicate options
- Producing the first shapes – It’s not pretty but it’s starting to come together
- Sorting a collection and finishing off complete tool – how to apply complex sort terms taken from a parameter sheet and sort a collection
- Hiding data in Excel Shapes – embedding JSON data in excel objects
- Sudoku Solver and Generator: For advanced skills.A project to create a sudoku generator and solver, to illustrate the use of classes and recursion
- Basic Solver – Using recursion to apply Sudoku strategies to solve a Grid
- Brute force Solver – More extreme recursion needed as first step in generating a human solvable grid.
- First Generated Puzzle – More recursion as we remove cells from our skeleton grid to leave a solvable puzzle
- Soak Test – testing and optimizing something that is random.
- jSon. is now the preferred method for interacting with web services across the Internet. This site is full of examples of projects which rely on jSon. The heart of all of this is the cJobject class – see How to use cJobject which gives javaScript like hierarchies to VBA. The serialization of jSon data is very dependent on recursion. Here are some projects that use cJobject
-
- jSon
- Excel JSON conversion
- jSon and Dynamic Forms
- Hiding data in Excel Objects
- Web Services
- Get Data from Google Books
- Get Data From Google Docs
- Execute SQL from Excel
- Complete Excel Address Data with Google Mapping API
- Data-Driven Mapping applications
- Cookies and Excel
- Serializing Excel data for Google motion charts
- Complete Excel Address Data with Yahoo Placemaker Maps API
- Adding markers to Google Maps from Excel
- Using Twitter in Earth and Maps
- Using Google Earth – creating KML files
- A tagCloud in Outlook
- Data Manipulation Classes
- Excel Comment shapes
- Roadmap generation
- How to create a tag cloud
- Adding markers to Ovi Maps from Excel
- Rest to Excel library
- Rest Results Explorer
- How to traverse a treeview
- … and many more
For help and more information join our community, follow the blog or follow me on Twitter