This is a real-world scenario – you need to implement some sophisticated manipulation of Excel tables in VBA, and then you need to extract the data from the Open XML spreadsheet using the Open XML SDK. This screen-cast was based on a real-world project that I completed a short while ago. The customer wanted some slick behavior inside a spreadsheet. They wanted to automatically create tables, delete tables, and in some circumstances, to maintain the tables. After the data was as desired, then the user would save the macro-enabled workbook, and run an Open XML program that processed the data in an interesting way (that would be very difficult using VBA).<\/p>\n
This screen-cast and example code are related to two other videos:<\/p>\n
Using Open XML Package Editor to Create a Ribbon Button that runs a VBA Function<\/a><\/p>\n