Why did I create this blog? Because I have been using Excel and its related technologies for a very long time--since Excel 3.0 on Windows 3.x, and still run into problems.
Of course, one can search for Excel related articles on the Internet, but they are inevitably of the simple variety, such as how to use VLOOKUP et al.
There needs to be a resource for really advanced Excel users. I don't mean just how do I do something in VBA. I mean more difficult problems, such as... How do I use the Bloomberg API from Excel VBA? How do I create CLR hosted COM controls that are Excel dispatch automation compatible? How can I pass arrays of structures from VBA to managed code?
Many times I've thought--there should be a book on this. I suppose I could write a book, but I've decided to write a blog instead. So here it is...
No comments:
Post a Comment