Iceberg Code

Thank you visiting ICB - Iceberg Code Blog
This is the place, where I'd like to share ideas and some useful code (VB, Excel, T-SQL, JavaScript, ...)
Table of Content

This is part one of two post.
When you work on your own, you don't care to divide you big workbook in a multitude
of smallest files to deploy to tens of users that must see only they own piece.
... and Excel become a nightmare.
How do you split a 10 thousands row worksheet into 200 X 50 workbook?
Or how do you split a workbook with 5 different sheets?
I worked out this solution:
SplitExcelFile.xls

You just need to set:
1) Which worksheet split, and the name of the field that must be split
2) the list of value to split and
3) the parametric name of all the output workbook.

Enjoy it!