32 posts tagged with macros.
Displaying 1 through 32 of 32. Subscribe:

Need quick and dirty VBA/Macro help in Word

Conditional Formatting a drop-down list in a Word Document [more inside]
posted by Ruthless Bunny on Mar 10, 2016 - 4 answers

Where can I find a library of Macros for Excel and what they do?

I've been recently getting interested in various Macros and what they can do in Excel. Is there suppository of various Macros available online as well as clear demonstrations of what they can be used for that I can insert into my spreadsheets.
posted by RapcityinBlue on May 7, 2015 - 3 answers

Inserting symbols before and after some other text in Excel (macros?)

Is it possible to do this in Excel or Word or some other program?: I want to paste a sentence into the a text field, highlight a word or several words in that sentence, hit a keyboard shortcut, and have certain symbols inserted before and after that word or phrase. For example, in the sentence "Metafilter is the best website in the whole wide world," I might highlight "website," press the shortcut, and have it transform into the following: "Metafilter is the best {{c1::website}} in the whole wide world." I'm using OSX and Microsoft Office 2011, but I'm comfortable doing this in a webapp or Google Drive or whatever you suggest! I also have the aText text expansion software, but I can't figure out how to make it insert text at both ends of a highlighted phrase. [more inside]
posted by lizzicide on Jul 25, 2014 - 7 answers

Best resources for learning Google Apps Script?

The company I work for is starting to use Google Docs more frequently. I'd like to jump in with both feet. One of the things I'm most interested in is getting up to speed on using Google Apps Script as an end user who makes frequent but basic use of macros in Excel (so not so much as a developer or other high skill user). What are the best learning resources for this? Books, online tutorials, webinars, etc. anything is fine, just trying to figure out where to begin.
posted by Lentrohamsanin on Jun 26, 2014 - 2 answers

Looking for an advanced Excel/Access crash course

VBA and Macros and VLookup, Oh My! I might be ending up on a work assignment where they want someone who can create and edit complex Excel templates that interface with Access and Adobe Forms. I've used all these programs extensively, but I've only used advanced features sparingly (either editing someone else's creation or googling for a specific fix for a specific problem.) Difficulty level: I only have a week to cram on this before I would start. Is it possible for a quick learner to get up to speed enough not to crash and burn on a project like this? Can anyone recommend an online course I could binge on before having to take on this project?
posted by firechicago on May 19, 2014 - 2 answers

Making Excel do stuff for me, automagically!

Where can I find snippets of vba macros that I can use/reuse? What are your favorite macros that you use and can't do without? [more inside]
posted by rippersid on May 18, 2014 - 3 answers

Create keyboard shortcut to "highlight" selected text in Word 2011 (Mac)

I have successfully created a keyboard shortcut to insert a new comment using the Tools > Customize Keyboard menu in Word. (I assigned it to Cmd+7, which is unassigned.) I want to highlight selected text yellow using Cmd+9, which is also unassigned. The same process won't work, and I can't seem to record a macro to do this either. Any Word Wizards/Wizardesses able to help? Many huge thanks in advance.
posted by metarkest on Mar 19, 2013 - 1 answer

Stinky Linky!

Is there a way to define a link by the number of links into the webpage it is? [more inside]
posted by ian1977 on Apr 2, 2012 - 2 answers

Please use small words not written in VBA

Conditional Images in Word. It must be possible, but how hard is it, and am I just looking in all the wrong places for an answer? [more inside]
posted by instead of three wishes on Feb 17, 2012 - 7 answers

Excel is the death of me!

I have about 200 separate Excel spreadsheets that I need to change one field in. There is a date in G4 that needs to be the same in each sheet. Is there way way to do this without opening, editing, and saving each sheet one at a time?
posted by keep it tight on Dec 19, 2011 - 10 answers

MacroFilter: I am trying to make a code snippet for Word work and don't understand why it's not working.

MacroFilter: I am trying to make a code snippet for Word work and don't understand why it's not working. [more inside]
posted by Calzephyr on Sep 10, 2011 - 10 answers

Excel math puzzle

Excel question. Is there a way to determine a list of all possible values from a list that add up to a given total? [more inside]
posted by xedrik on Dec 14, 2010 - 4 answers

Microsoft Excel or Substitute?

Microsoft Excel substitute (Open Office seems not to work) needed to open a spreadsheet (directory of businesses) based on macros. [more inside]
posted by mbarryf on Aug 11, 2010 - 6 answers

There can be only one (Excel formula I have to update)

Excel guru filter: I want to change this formula every week, and have the change cascade across 20 tabs of independent data. [more inside]
posted by deludingmyself on Jul 3, 2010 - 7 answers

How to: Word Macros with User Input?

WordMacroFilter: I'm trying to set up a Word Macro using find and replace but that waits for user input... [more inside]
posted by Zinger on Jun 10, 2010 - 4 answers

opening a macro file on a mac

Any way to open a file with existing macros in Mac Microsoft Office 2008? [more inside]
posted by eggerspretty on May 10, 2010 - 6 answers

Trying to find Excel VBA code for "round dot" gridline.

Excel VBA question: help me insert a "round dot" gridline in my chart. [more inside]
posted by mullacc on Apr 18, 2010 - 8 answers

I need to write a macro to reformat daily reports, which can't be changed upstream, using regex and global replace.

I need to write a macro to reformat daily reports, which can't be changed upstream, using regex and global replace. [more inside]
posted by johnofjack on Mar 15, 2010 - 14 answers

Another GD excel question

Another, once again, excel question on fill colors [more inside]
posted by TheBones on Jan 5, 2010 - 11 answers

Transitioning from Mac to PC: Is there an expose-like feature? Your tips for coping with the transition?

Transitioning from Mac to PC: Is there an expose-like feature? Your tips for coping with the transition? [more inside]
posted by NikitaNikita on Sep 22, 2009 - 16 answers

Help save me from excel hell!

Another crazy excel question- I can't promise this won't be my last one. [more inside]
posted by TheBones on Sep 2, 2009 - 8 answers

automefi: entering a sequence of keystrokes on a mac. Free software?

I'd like to automate my mac to do keystrokes. Like, flicking between an excel spreadsheet and firefox. I'd like free software to do this. Any suggestions? [more inside]
posted by omnigut on Jul 20, 2009 - 7 answers

Is there a sane way to batch-convert a year of expenses from one currency to another in Excel?

Excel n00b filter: Is there a way to automatically convert an expense sheet from one currency to another by matching the date the cost was incurred with the exchange rate applicable on that specific day? [more inside]
posted by doctorpiorno on May 29, 2009 - 6 answers

Where are custom settings stored in Word 2000?

What file are settings (created macros, custom toolbar buttons, etc.) stored in in Word 2000? [more inside]
posted by roxie110 on Jan 18, 2009 - 2 answers

bar code or just go to a bar?

How could I write a macro to format my data like I need it? [more inside]
posted by keep it tight on Oct 23, 2008 - 12 answers

Much macro madness?

Where can I find a repository of Word macros? [more inside]
posted by Zinger on Oct 3, 2007 - 3 answers

Where did my macros go? what macros do you use?

My MS Word (2003 version) macros keep disappearing! What gives? While I'm at it, what macros do you use? [more inside]
posted by timnyc on Feb 13, 2007 - 2 answers

Remembering window locations in XP

Is there a program to reposition different windows on the screen the way you want them to be? (windows XP) [more inside]
posted by philosophistry on Dec 1, 2006 - 3 answers

Help me optimize a list in Excel.

Help me optimize a list in Excel. (Excel gurus welcome!) [more inside]
posted by pealco on Sep 28, 2006 - 3 answers

Office of OS 9 Macros not working too well in OS 10.4

When I try running long complex macros in MS Word for OS X, created in Office for Mac OS 9.2, some of the macros are freezing/crashing. Perhaps even worse, the macros don't seem to be failing at the same point each time I try to run them. [more inside]
posted by ParisParamus on Jun 15, 2005 - 1 answer

How to get Word to open the next drop-down automatically?

I have a Microsoft Word document template containing many drop-down form field elements. How can I get Word to advance to and display the choices for the next drop-down automatically when a selection is made? [more inside]
posted by teleskiving on Mar 28, 2005 - 0 answers

That was easy!

I want a big red button with a USB connection that I can program a macro to, like mute all sounds or something. I found some promising looking devices (X-Keys and Switch Click), but this isn't something I want to spend a hundred bucks on. Radio Shack has a red button for $2. Any ideas on how to make something like this work?
posted by andrewzipp on Feb 10, 2005 - 19 answers

Page: 1