{"product":{"product_id":"0321508793","title":"Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA, and .NET","price":"137.02","image_url":"https://m.media-amazon.com/images/I/515VYgFjIWL._SL500_.jpg","url":"https://www.amazon.com/dp/0321508793"},"comments":[{"body":"Have you explored converting the VBA to a COM add in? \r\n\r\n\r\nEdit:  \r\n\r\n* Consider posting this over at /r/excel.\r\n\r\n* Check out the book Professional Excel Development: http://www.amazon.com/Professional-Excel-Development-Definitive-Applications/dp/0321508793","subreddit_name":"learnprogramming","author":"---sniff---"},{"body":"This sounds like something right out of [Professional Excel Development](http://www.amazon.com/Professional-Excel-Development-Definitive-Applications/dp/0321508793).  My copy is at work so I can't check right now but if anywhere would have an answer it would be that book.","subreddit_name":"excel","author":"---sniff---"},{"body":"[Professional Excel Development](http://www.amazon.com/Professional-Excel-Development-Definitive-Applications/dp/0321508793/ref=sr_1_50?ie=UTF8\u0026amp;qid=1332124902\u0026amp;sr=8-50) by Bovey provides step-by-step instructions to build a time keeping program.  The CD that comes with it has the final product.","subreddit_name":"excel","author":"---sniff---"},{"body":"https://www.amazon.com/Professional-Excel-Development-Definitive-Applications/dp/0321508793/ref=nodl_\r\n\r\nExcel Macro Mastery course online too, great resource.","subreddit_name":"vba","author":"Competitive-Zombie10"},{"body":"In case anyone else is also interested, I found this book to be a fantastic resource. It teaches Excel, but more it actually teaches how to create professional workbooks: [https://www.amazon.co.uk/Professional-Excel-Development-Applications-Addison-Wesley-dp-0321508793/dp/0321508793/ref=dp\\_ob\\_title\\_bk](https://www.amazon.co.uk/Professional-Excel-Development-Applications-Addison-Wesley-dp-0321508793/dp/0321508793/ref=dp_ob_title_bk)\r\n\r\nI don't get to use Excel much, these days, but this book plus some prior Excel experience was *extremely* valuable for solving general business problems.","subreddit_name":"excel","author":"DigitalStefan"},{"body":"The exact book you are looking for is called Professional Excel Development.\r\n\r\nhttps://www.amazon.com/dp/0321508793/ref=cm_sw_r_awdo_BBJB3NFNMG7PFJDFRTHR","subreddit_name":"vba","author":"syphilicious"},{"body":"This is not Excel, but for R - but the basic principles are the same: [https://r4ds.had.co.nz/tidy-data.html](https://r4ds.had.co.nz/tidy-data.html)\r\n\r\nAlso, a book I used and which was very helpful to dig deeper into the possibilities of Excel is Professional Excel Development by Bovey, Wallentin, Bullen, Green - My edition is from 2009, so it is a bit dated, but still - same principles still apply.  [https://www.amazon.de/Professional-Excel-Development-Applications-Addison-Wesley/dp/0321508793](https://www.amazon.de/Professional-Excel-Development-Applications-Addison-Wesley/dp/0321508793)","subreddit_name":"ProgrammerHumor","author":"ojessen"},{"body":"Looks interesting, but it only covers up to version 2007.\r\n\r\nEdit: link for the lazy.\r\nhttp://www.amazon.com/Professional-Excel-Development-Definitive-Applications/dp/0321508793","subreddit_name":"vba","author":"barefoot_dude"}]}