Friday babble and a book request

[selenay]

It's Friday! Woo!

Tomorrow I am destined for the bright lights and big bookshops of London on a day trip with Da :-) Intend to hit Waterstones in Picadilly and Foyles with lots of booktokens. If anyone has any recommendations...

*g*

I've got a list already of things that I'll be looking for :-)

For the Naomi Novik fans on my f-list, she's been nominated for the Hugo Best Novel and the John Campbell award, both for Temeraire. Woo! For the non-fans - why haven't you tried her books yet? ;-)

The important part of this post is a book recommendation request with a technical slant. Many of you may know than I have to use VBA extensively in my job (yes, yes, Microcrap sucks...) and we currently have no reference text except for my mad Googling skilz (TM). Obviously this isn't helpful for the newbies or for me when I can't get a search term that will actually provide useful results. So the boss has finally agreed to buy us a couple of reference texts for the department provided I can find some good ones.

Any suggestions? We mainly use VBA for Excel, so something with a focus on that would be most useful, but we also automate Outlook things from Excel and I'd like to see whether we can do some PowerPoint automation as well so it would be useful if some of that was covered. I'm not looking for a Learn in 24 Hours kind of thing, more of a reference that I can flick through when trying to figure out how to do the latest crazy thing I've been asked for.

With so many techies on my f-list, surely one of you has had to deal with VBA and can suggest something for me to look at?

Comments

[historyterry.livejournal.com]

While you're in town, see if you can find time to get to Sicilian Avenue (Holborn), as there is a computing bookshop there, and the staff frequently know their stuff:

http://www.multimap.com/map/browse.cgi?client=public&GridE=-0.12149&GridN=51.51866&lon=-0.12149&lat=51.51866&place=Sicilian%20Avenue%2C%20HOLBORN%2C%20WC1&db=GB&scale=5000&search_result=Sicilian%20Avenue%2C%20HOLBORN%2C%20WC1&lang=&db=GB&keepicon=true

[selenay]

Thanks for the suggestion :-) Unfortunately, we only managed to do Waterstones in Piccadilly and Foyles due to the length of time we spent in each! I will keep that in mind the next time I need some reference material, though.

[paranoidangel]

The VBA book that two people in the company have entirely independently, and one of whom is me, is called VBA and Macros for Microsoft Excel by Bill Jelen "Mr Excel" and Tracy Syrstad ISBN 0-7897-3129-0 (http://tinyurl.com/294ebs at amazon)

[selenay]

Thank you for that one. I took a look at it while I was shopping and it's gone onto my short-list. I'm currently looking at either that one or an O'Reilly book that seems pretty good. If I can pursuade the boss that we need both...

*g*