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
I have a scenario where I have to evaluate work performance. There are 5 categories I'm evaluating. Now when the person fails to meet a benchmark, I want to send him a letter explaining why he didn't meet the benchmark. So I have 5 paragraphs (one for each category) that explains what was wrong and how to fix it. Instead of copying and pasting from a document to create the letter, I'd like to be able to select from a list of responses, and have those responses formatted in a letter form. More after the the jump.
[more inside]
posted by FireStyle
on Mar 9, 2013 -
8 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
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
Endless paperwork! How do I automate filling out a .doc form? Challenge: cannot involve downloading/installing any new software
[more inside]
posted by Wretch729
on Oct 5, 2011 -
5 answers
Why does my one-pager in Word for Mac become a two-pager when I open it up in Word for Windows?
[more inside]
posted by andrewesque
on Jun 15, 2011 -
16 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
Is there such a thing as an "advanced" spelling and grammar program for Microsoft Word or WordPerfect? Bonus points if it is designed for the legal world.
[more inside]
posted by 2legit2quit
on Jul 25, 2010 -
14 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
I have some Macros that run in Word. We are migrating to Office 2007. Problem: the MsgBox function appears to lock all open windows of word. Any Ideas on how to get around that?
[more inside]
posted by Amby72
on Feb 4, 2010 -
1 answer
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
WordMacroFilter: So my new boss is great but he has some crazy grammar and wordsmithing quirks. I received a list (no joke) of the edits he wants to see of documents that come to his desk (use affect instead of impact, effect instead of impacts, etc). I'd like to create a Microsoft Word Macro that will automate the task.
[more inside]
posted by roundrock
on May 19, 2009 -
7 answers
Has anyone taken the Office Proficiency Assessment and Certification (OPAC) test recently, or have documentation on what
exactly it tests for in Word and Excel?
[more inside]
posted by limeswirltart
on Mar 6, 2009 -
3 answers
I have a Mac user whose Word documents are suddenly opening as lime green text on lime green background. This is only on her machine, anyone else can open the same documents and have them show as black text on a white background.
Office 2008, OS X 10.5
posted by mr_crash_davis mark II: Jazz Odyssey
on Mar 2, 2009 -
2 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
How do I make previous revisions, "track changes" comments, and other marginalia disappear,
and be unretrievable in Word?
[more inside]
posted by roofus
on Nov 27, 2008 -
19 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
Creating a
form template for colleagues to use at work that needs to meet the following criteria:
1. Allow text fields and drop-down selection boxes.
2. Allow users to add additional text in should they see fit (i.e. doesn't disallow all input outside of form fields).
3. Will allow rows (the form will be arranged like a table) to be duplicated/copied & pasted, including the form fields contained within those rows.
4. Is formatted nicely enough to be passed along to a client and read clearly.
5. Is openable/usable by your average user who doesn't have access to super expensive/specialized software.
[more inside]
posted by freudenschade
on May 1, 2008 -
9 answers
Is there any way to view pages in a Microsoft Word (2002) documents side by side instead of top to bottom?
[more inside]
posted by bigcheesegump
on Feb 25, 2008 -
6 answers
Word 2003 won't open after double-clicking on a document, and the mouse doesn't work in the document area.
[more inside]
posted by BeerFilter
on Jan 9, 2008 -
5 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
How to change the program Word opens embedded audio with? Alternatively, suggestions for foot-pedal software that plays well with audio embedded in Word or RTF documents.
[more inside]
posted by icebourg
on Jul 16, 2007 -
3 answers
Microsoft Word Training Filter: Can anyone recommend any good, comprehensive online training courses for Microsoft Word 2007. Bonus points for: free or cheap.
[more inside]
posted by Zinger
on Jun 26, 2007 -
4 answers
How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like
this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row.
[more inside]
posted by bokinney
on Mar 12, 2007 -
7 answers
Unicode Filter: Converting an Office 98 document to Unicode has caused formatting problems.
[more inside]
posted by AArtaud
on Feb 22, 2007 -
4 answers
Legal forms: I'm looking for a free or low-cost application that will permit data entry in a user-friendly environment and integrate that data with an indeterminate number of predefined MS Word forms (and output .doc or .rtf documents).
[more inside]
posted by socratic
on Nov 16, 2006 -
3 answers
Word is starting to drive me insane. Is there any way to force it to use only the styles
I defined, and not clutter the list with every minute variation of those styles?
[more inside]
posted by Harry
on Sep 16, 2006 -
6 answers
