Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Aside from random googling, any good reference material to be found either online or in that old "book" format?
Some clever chap at work is reaching limits of his knowledge of Outlook VB, and looking for suggestions for material; my thoughts immediately came to you lot!
Thanks, Rich
You could try asking on somewhere like http://stackoverflow.com/
Started by the guy who developed VBA in office, Joel Spolsky.
I found this to be a good reference book (more from the VB side than VBA but I'd expect it to be just as useful):
[url= http://shop.oreilly.com/product/9781565923584.do ]VBA in a nutshell[/url]
The biggest problem with VBA in office is that the VBA part is the easy bit, the complexities of the application Object model is the hard part and often the problem is figuring out how to do something as there as so many possible ways and not all work that well eg I spent most of yesterday crashing Excel trying to embed OLEObjects in Graphs. In the end I gave up and used a crude workaround to achieve the same result.
i've done some stuff with outlook vba, the object model is out there [url= http://msdn.microsoft.com/en-us/library/vstudio/ms268893.aspx ](2013 version)[/url] but the main problem i found was the lack of many people playing with it and therefore forum threads suggesting ways to fix things
Yep - I spend my life on VBA Excel forums looking stuff up. Unsurprisingly the forums beat MSDN hands down on useful info!
Ooops, just remembered I didn't say thanks for the info above - apparently it was all helpful thanks!