I need some guidance in writing a macro that will parse a glossary Word document and reformat it into an Excel spreadsheet with the term in one column and the definition in a second column. [more inside]
Where might I hire someone to write a short Outlook 2013 macro, beyond my own "Google it, paste, and splice together" capabilities? (Metafilter Jobs yielded no takers.) What price should I be willing to pay for the described job?
I often (upwards of 15 times a day) need to select some of the text within a cell or textbox in Excel, and format it bold and red. Not all the text in the cell/box -- just the text I select. Is it possible to write macros to do this task? And where should I go to find someone to write it? [more inside]
My wife loves taking tight photos of flowers, bees and other stuff of that scale. She's not really trying to do true macro photography and I'm not entirely confident that she'd have the patience to deal with a complicated DSLR. I know that all the new point and shoots out there are capable enough to do closeup work and this question has been covered in previous years but I'm wondering if there are any standouts in the late 2014 camera lineup. [more inside]
I'm trying to test if a a series of cells exist, and then concatenate the values that do exist with a paragraph I have. [more inside]
What is the quickest and most accurate way to undo manual tabbing in Word and reformat those lines with paragraph alignment? [more inside]
The macro recorder in Microsoft Excel allows me to automate repetitive tasks with relative ease. Is there something similar that would allow me to do the same thing outside of Microsoft Excel? I'd like to be able to record my keystrokes and mouse movements in a similar way, regardless of which program I'm using. I'm using Windows 7.
I have discovered the joy of taking photos of teensy, tiny things - like baby snails! - and would like to move beyond my cellphone's camera. Since this is a hobby, not a new career path, I'd like to spend as little as possible, and definitely remain well-under $1,000 (CAD), while getting great results. Any advice? I need to be able to buy this camera in Canada, please! [more inside]
I am using Excel 2011 on Mac OS X Lion. I have a workbook created by a colleague with 25 worksheets in it. I would like to export all of these to individual csv files. Is there a way to do it all in one batch? [more inside]
I have a 100-page Word document full of miscellaneous content from different websites. Unfortunately, after each section taken from a website, there's basically a citation for where the content was taken from that contains the URL for the website. I need to find a way to find all these hyperlinks and delete them completely from my document. They're all from different websites, so really, the only commonality is the "http://" part.
Is there a simple way to assign a keyboard shortcut to a macro in Access 2007? I understand that macros behave differently in Access than they do in Excel (which I'm more familiar with). I have written a sub called "ImportAll" in Module1. I'd like it to run when I push Ctrl+I. How would I go about achieving this?
Is there a way (a macro perhaps?) to change the spellings and punctuation in a Microsoft Word document (.docx) from "American" style to "British" (or should I say, 'British') style in one fell swoop? [more inside]
Help me find the basics for indoor macro photography. I have a DSLR and Macro lens. I need cheap lighting and a set. Preferably small or easily storable when not in use. [more inside]
How can I set a mouse button on my wireless Logitech mouse to play a series of keystrokes when pressed? [more inside]
Is there a web-based (or Mac+iOS) outlining tool which allows you to enter a task or item to be placed on the outline without selecting which section it should go into first - but is able to quickly assign that task or item to a section from the keyboard without a cut and paste operation? [more inside]
How can I assign a command to a mouse button so that a .jpg will open in MSPaint? [more inside]
Automator/macro/scripting help: Is there a way to automate a series of keystrokes, initiated by a command that I create? Running Mac OS 10.7.3. [more inside]
Is there a way to define a link by the number of links into the webpage it is? [more inside]
I'm trying to find an image macro I saw about having trouble plugging in USB cables. [more inside]
Help me understand how to make a macro do what I want it to do - automatically select the relevant area instead of a previously recorded cell range. [more inside]
I need to Auto BCC myself on all mail I send through Outlook 2010 from one (and only one) of my Exchange accounts. How can I do this? [more inside]
Explain to me Excel macros and how I can learn to program them (assume that I know absolutely nothing, because that would be correct). [more inside]
Paging macro photographers. I need help taking great photographs of tiny bugs (sub-questions on eye-fi, focus stacking, and lighting). [more inside]
Firefox / WIN7: I type in two hyphens IE -- and word processor (LibreOffice Writer) changes them into M dash IE – which is what I would love to see happen in Firefox. Alternately, if this cannot be done, is there a simple way to do this with some sort of macro on my puter? Plus, hey, while we're here, can we turn three periods IE ... into an ellipsis IE … ? (Hewlett Packard HP 630 laptop, if it matters.) [more inside]
I need a lens for low-light, hand-held, food photography on my Canon 40D. I will be renting the lens so cost is not an issue and prefer only one lens instead of swapping them out. I will be taking pictures in restaurants during actual meals so dishes must be fully framed from the seated position. No tripod, no flashes, no standing up, no trickery. What would you recommend?
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]
Using various relatively cheap adaptors, zoom lenses and lens-reversal rings (the greatest thing that ever happened to Nikon dSLRs!), I had fun taking lots of pictures of really tiny things with my previous cameras. However, now I have a Sony NEX-5k which, for its wonderful optics, great features and excellent resolution doesn't seem to have anything that I can find to do the same type of work. Can anyone recommend a hack or accessory that will let me take more pics like those I used to (or even of smaller things!)?
Is it possible to set up a script or macro to run periodically on my Gmail inbox? [more inside]
How do I create a macro in Excel that copies the contents of the cell two cells to the target's right and appends the contents to the end of the target cell? Both cells contain alphanumeric strings. [more inside]
Excel-macro filter / this-must-be-possible filter: copy and paste a cell (say, A2) into Google Maps, hit submit, then copy and paste the first phone number into an empty cell (say, A10). How to make it work? [more inside]
Can anyone help me identify this meme/macro? The usual format is something like "What are you doing there, you're an X, Xs can't Y." It's usually on a picture of something unusual, as in the example. If anyone knows the name of this meme or where I can find more of them, I'd appreciate it. Thanks!
I need help with some terminology of scale. Is there a term for something on a scale between "meso" and "micro"? Alternatively, I'd be happy with something higher than "macro" or between "micro" and "nano" (but I'd rather avoid that one if possible). [more inside]
Does anyone know how to insert an automatically updating visio diagram into a Word file without it looking like complete crap? [more inside]
What sort of strategies do macro hedge funds employ? [more inside]
I have a database in Access that is essentially a list of projects and associated tasks. I have a query that lists all projects due in the next 30 days. How can I automatically generate an email from this query? Ideally this would just magically send an email whenever the query is populated with a new project. [more inside]
I'm in the market for a new camera lens. I'm attempting to do my "due diligence" - if I'm going to pony up and drop $500 - $600 on a lens, I want to make sure it's right - but a lot of this information doesn't make sense to me. Step inside, would you? [more inside]
I have a document that has 4 identical postcard sized signs that display a constantly changing date. I'd like to put a macro button in (either Word or Publisher) that will open up a dialog box and allow me to type in the date, and have it auto-populate into the appropriate 4 places. [more inside]
Is to possible to map several addresses from an excel spreadsheet on Google earth, Google maps, etc. using a macro? [more inside]
MS Excel gurus: I am looking for a way to export the data from a spreadsheet so that it can be displayed in a Word document as text, with the column-headers as lead-ins for each cell of data. Basically I want to turn this into this. [more inside]
Another, once again, excel question on fill colors [more inside]
It's time for a new digital camera. Please help guide me, as I feel overwhelmed by the research process. I am looking for suggestions of specific cameras OR features I should be searching for in a camera. Specific requirements inside. [more inside]
I came into possession of a Sun type 6 keyboard and want to see how much use I can get out of it in Windows. [more inside]
What camera and lens combinations would you suggest for a DSLR for macro/indoor photography (without flash) for a newbie? Price range around 1200 USD. [more inside]
Where can I find a freeware macro recorder (with smart recording ability)? [more inside]
Need help developing a Excel VBA Macro to Vaildate data entered into a textbox [more inside]
Please help me create an excel macro to hide rows given a certain criteria. [more inside]
I have a column of around 100 equations that can only be solved with solver in Excel. Is there any way to create a macro for this purpose. The layout of the spreadsheet given below. [more inside]
How can I set up Excel 2003 to automatically include the file name and path on every spreadsheet when printed? [more inside]
Simple problem: record a macro and play it back in firefox. Hard part: recording a macro and playing it back in firefox. [more inside]
Another crazy excel question- I can't promise this won't be my last one. [more inside]