I have read that John Walkenbach's books are the de-facto standard for learning to use VBA in Microsoft Excel. I'd like to know what books are recommended to learn to use vba in other Office products - primarily Access, but also Word and Powerpoint. I'm more interested in books than in websites.
posted by Proginoskes
on Apr 6, 2013 -
3 answers
How might I recover an Office 2010 product key from a Windows install now located on an external hard drive?
[more inside]
posted by dumbland
on Dec 19, 2012 -
4 answers
I bought a Thinkpad through Gumtree (UK) last year and now Microsoft Office Professional Plus 10 is asking me for an authentication code. When I got the computer, windows had just been installed but I don't know if I got a trial version or a corporate version that was imaged onto the machine. Do I need to pay for an authentication code or is there a way to otherwise disable the authentication request message?
posted by parmanparman
on Aug 7, 2012 -
3 answers
Switching from Word for Mac 2004 to Word for Mac 2011. Formatting and compatibility issues. Really truly clueless. Help?
[more inside]
posted by greta simone
on Jan 18, 2012 -
12 answers
An important, newly ISO-9001 standard form in my office is an Outlook template (*.oft) that we have to fill out. I use a Mac with Entourage. How do I fill out this form?
[more inside]
posted by olinerd
on Oct 25, 2011 -
3 answers
Microsoft Word 2010 doesn't seem to recognize some of my keyboard inputs. Maybe due to the language my keyboard is set. Can't figure how to customize or otherwise tell it that a [set keyboard shortcut] is already equated to a [set character].
[more inside]
posted by CelebrenIthil
on Oct 25, 2011 -
5 answers
Can anyone recommend a good, well-trafficked forum for Microsoft Office (particularly 2010) questions? Seems like this should be eminently Googleable, but maybe because there are so many of them, I'm not finding the one that is
the one. Thanks!
posted by The Dutchman
on Mar 19, 2011 -
7 answers
How would one go about the task of recording the word-counts of hundreds of MS Word documents? Is this something that could be automated?
[more inside]
posted by cac
on Feb 24, 2011 -
4 answers
I often write in several languages (French, Dutch, and English) and so I use multiple keyboard layouts (on Windows 7) and multiple editing languages (in Microsoft Office 2007). I find that when I have Word open and I change the keyboard setting in Windows (from US to US-International or vice-versa), Microsoft Word will change the editing language back to English (United States), Word's default language, no matter what other language (Dutch or French) I was working in at the time.
[more inside]
posted by dhens
on Oct 4, 2010 -
4 answers
Excel 2007 filter: How do you change the dictionary language for specific cells/columns/rows?
[more inside]
posted by bethist
on Oct 1, 2010 -
3 answers
How can I get Outlook to create a
text link to an email instead of a graphical icon link when drag-and-dropping into another MS app?
[more inside]
posted by sprocket87
on Sep 29, 2010 -
5 answers
Purchased MS Office 2010 Academic version yesterday. Exceeded 25 download attempts somehow. Is there another place I can download from?
[more inside]
posted by fallsauce
on Sep 26, 2010 -
2 answers
Outlook->Access->Word Merge: A client asked me to help merge from Outlook to Word in order to be able to print out the contacts
with Notes field.
[more inside]
posted by geekyguy
on Jun 21, 2010 -
9 answers
Have you used CrossOver Linux (the Codeweavers version of Wine)? Does it work well with MS Office 2007? I've installed regular Wine and MS Word on my (Fedora 12) computer, and it works like crap. I was curious if the commercial version worked any better. Thanks.
[more inside]
posted by bluefly
on May 7, 2010 -
10 answers
Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card.
[more inside]
posted by beammeup4
on Mar 23, 2010 -
7 answers
How do I keep a particular tab in Word2007 from automatically disappearing? And other Word2007 and Excel 2007 questions inside.
[more inside]
posted by jujube
on Dec 17, 2009 -
15 answers
I'm looking for a job doing presentation graphics (in law firms, possibly financial firms); this is about 30% of my current job at a law firm. I'm one of very few "experts" at my firm which isn't very technologically advanced in this area, so I'm afraid that my skills won't cut it in the outside world. I need advice on how to upgrade my skills.
[more inside]
posted by kenzi23
on Sep 30, 2009 -
2 answers
I'm writing in Word for Mac and all of my footnotes have suddenly turned into little boxes. What's going on?
posted by anonymous78
on Aug 13, 2009 -
4 answers
I need MS Excel and Word to play together nicely. I can do what I need to in Word, and I can do what I need to in Excel; it's the Relationship that's Complicated. Maybe I need workflow advice? Basic knowledge? Please, please keep reading.
[more inside]
posted by cheeken
on Feb 5, 2009 -
14 answers
In Office 2007 Microsoft has changed the user interface radically. I'm interested to find material which describes why they did that ?
[more inside]
posted by southof40
on Dec 17, 2008 -
25 answers
Mac OS X / Microsoft Office 2004 (Excel) crash and failed file recovery has left excel in an endless loop of restore and crash. Can anyone help me to find and delete the (unwanted) auto-saved excel sheet that is causing this problem?
[more inside]
posted by urban greeting
on Dec 4, 2008 -
3 answers
A couple of weeks ago I had to do a System Restore on my PC, after which I had to reinstall Microsoft Office (2007). Ever since, every time I I open an office program like word or Excel, the program has to go through a long configuration process.
[more inside]
posted by Sara Anne
on Nov 14, 2008 -
4 answers
How to do a VBA version of the following array formula in Excel?
The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA:
{="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)}
[more inside]
posted by Mokusatsu
on Oct 17, 2008 -
3 answers
Why are we getting incomplete printouts when attempting to print wirelessly from a laptop?
[more inside]
posted by newfers
on Aug 19, 2008 -
3 answers
Buying Office 2007 Small Business Edition online - new, sealed, licensed and legit. Where from ?
[more inside]
posted by southof40
on Aug 19, 2008 -
11 answers
Can I actually buy an Office 2007
DISC? As in, the
actual media? I have really struggled with this, since reinstalling Office 2007 on a reformatted 'Office-ready PC' is impossible: Reformatting obviously wipes out your Office install and the the trial version (which is the only thing available to download) is incompatible with (some of?) Microsoft's own license keys.
[more inside]
posted by chuckdarwin
on May 23, 2008 -
8 answers
Is there an actual name for the "Start Menu" user interface element in Vista? It also shows up in Office 2007 and holds all the "Open, Save As . . ." file operations.
[more inside]
posted by dhacker
on Mar 3, 2008 -
6 answers
Is there a way to use a google calendar and outlook exchange without completely mixing the two and can they be synced differently on different computers?
[more inside]
posted by D Wiz
on Jan 21, 2008 -
6 answers
How can I make Microsoft Word's Find-and-Replace feature work properly with regular expressions when Track Changes is on?
[more inside]
posted by Partial Law
on Oct 31, 2007 -
6 answers
Should be simple to insert a "text field" in a form template in Word 2007. Why isn't it?
[more inside]
posted by RavinDave
on Oct 21, 2007 -
4 answers
I have a Word merge document with merged variable info sandwiched around a preprinted area in which I want no text - is there a way to insert some sort of break on the page that says to Word "No matter how big section 1 is, don't start printing section 2 until this point"? Thanks for any help!
[more inside]
posted by deliriouscool
on Sep 21, 2007 -
8 answers
I want to set up a system where Windows will watch a folder for any Office 2007 files and then automatically convert them into Office 2003/2004 files.
[more inside]
posted by sammich
on Jul 26, 2007 -
4 answers
