Sometimes excel VBA code executes very slow. Sometimes it's really fast. I can't seem to pinpoint why. [more inside]
posted on May 21, 2008 - 8 answers

Photography/Microscopy mash up. My labmates and I are looking for a way to take pictures of crystals under the microscope. We are not a microscopy group. Scientists and/or macro enthusiasts please help! [more inside]
posted on Mar 31, 2008 - 9 answers

I need a Word macro that will go through a folder, run word/character counts on each file in the folder, and deliver a total count of Chinese/Japanese/Korean characters, ignoring all English. This seems like it shouldn't be hard to script, but insufficient leetness on my part (and the fact that I've never written a macro before) means I'm more or less clueless here. What am I missing?
posted on Mar 30, 2008 - 5 answers

Photography filter: Next step up from "digital macro"? [more inside]
posted on Mar 23, 2008 - 7 answers

How can I work some data magic and save time looking up hundreds of phone numbers with data from an Excel spreadsheet? [more inside]
posted on Mar 18, 2008 - 6 answers

How to "text to column" a cell with multiple lines in Excel? [more inside]
posted on Jan 24, 2008 - 7 answers

I'm an amateur photographer. I recently took some quite close up pictures of a white flowered plant. I thought I'd better turn the exposure down (to -1) to avoid the flash picking out the whiteness of the flowers too much. But it didn't work out so well... [more inside]
posted on Dec 30, 2007 - 18 answers

What do I need to know about before I get into macro photography? [more inside]
posted on Dec 3, 2007 - 14 answers

How do I get (and keep) lowercase cross-references in Word 2002/XP? [more inside]
posted on Oct 19, 2007 - 3 answers

I need to pass a macro/micro economics placement test. Though I took both of these courses during my undergrad, the information has left me. Which book (or books?) would be best help me demonstrate minimal proficiency in only a month or two of self-study?
posted on Oct 12, 2007 - 4 answers

I need to highlight a word, hit a combination of keys which will add text I specify before and after the highlighted word. I'm running Windows XP. [more inside]
posted on Oct 4, 2007 - 13 answers

I have a macro-enabled Word template. I want to create a macro that will replace the header and footer of the current document with the header and footer defined in the template attached to the document. Please help! :)
posted on Jul 28, 2007 - 1 answers

What's your favorite Nikon-compatible macro lens? I'm completely new to macro photography (and still pretty new to photography in general, having purchased my first DSLR a little over a year ago), and I'm leaning towards the Nikon 60mm f/2.8D AF, largely because of the price differential between this and some of the other Nikkor macros. Anyone have any great experience with some of the makeshift macro lenses (using extension tubes, reversing rings, etc)?
posted on Jul 23, 2007 - 9 answers

Ugh. I Can't believe i'm asking a (probably) stooopid ipod question-filter... [more inside]
posted on Jul 8, 2007 - 10 answers

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]
posted on Jul 2, 2007 - 10 answers

I have written a template with a macro for Word, which I would like to share with a bunch of other people. But I don't have a digital signature and I'm wondering if there's an easy or free way to get one, or a workaround? [more inside]
posted on Apr 27, 2007 - 3 answers

Could you post your own suicide video to YouTube? [more inside]
posted on Apr 26, 2007 - 22 answers

Can you help me find a particular Photoshop tutorial that I saw a while back? [more inside]
posted on Apr 14, 2007 - 5 answers

Creative solutions for making a (shudder) Macro Express Macro run on a remote computer within restrictive group policy (all windows) (remote desktop or vnc type solutions are out since that would be too much of a disruption to the user of the remote machine) ... means of triggering the macro: keyboard input (hotkey), schedule (won't work in this case - needs on demand), or the appearance of a window on the screen - this is the most promising I think - but the obvious solutions are eluding me... how can I make a harmless window open on a remote computer? (I've tried msg and psexec to run a bat file, but the remote server bits are all off limits due to group policy.)
posted on Mar 1, 2007 - 8 answers

NerdyCodeFilter-I have a need to automate the filling of forms for a particular website, the issue is...that I need logic... [more inside]
posted on Feb 8, 2007 - 11 answers

Help me remove unwanted spreadsheet info - I want to archive a massive buch of data from years of Excel spreadsheets but, I don't want to save all the extra gumph associated with macros and links in spreadsheets. [more inside]
posted on Jan 15, 2007 - 10 answers

MS Excel help needed. I need to set up some sort of automated merging macro in excel and am having trouble tracking down the best way. The details, and much [more inside]
posted on Dec 27, 2006 - 3 answers

Best digital camera to use in archives? [more inside]
posted on Sep 29, 2006 - 20 answers

Hello, I need an Access macro to run every Friday evening, automatically...can anyone help do this easily? [more inside]
posted on Aug 10, 2006 - 8 answers

Where can I find macro coupler rings online that won't cost a fortune to ship to Ireland? [more inside]
posted on Mar 8, 2006 - 3 answers

Looking for a macro program or method that captures and pastes text among different browser windows? [more inside]
posted on Jan 26, 2006 - 3 answers

I need help finding or creating a macro to transliterate Cyrillic characters to their Latin-alphabet, English-language "equivalents" without doing a massive find-and-replace by hand. [more inside]
posted on Sep 1, 2005 - 5 answers

So I'm trying to write a Word macro to count how many words there are on the current page of the document. It's not going well. [more inside]
posted on Aug 3, 2005 - 7 answers

I'm working on my MA thesis and so have an enormous jumble of books, articles, and references kicking around. I am looking for an easy way to manage this. [more inside]
posted on May 4, 2005 - 31 answers

Is there a macro program that will auto fire click for me? [more inside]
posted on Mar 15, 2005 - 5 answers

I've taken on a little mini project and I think the best way to get the job done will be to use one of those little bits of software which can copy and then simulate mouse movements etc. [more inside]
posted on Mar 12, 2005 - 14 answers

Web browser macros. I want to automate my interaction with a web site. [+]
posted on Feb 5, 2005 - 17 answers

Is there a plug-in or macro for Excel v.X or Excel 2004 for Macintosh that adds PivotChart (from Excel 2003 for Windows) functionality or compatibility?
posted on Jan 13, 2005 - 2 answers

Is there any way to make Excel macros less stupid? [MI]
posted on Jan 5, 2005 - 16 answers

I've come across this kind of very large¹, detailed, abstract illustrations, which are great for backgrounds or extracting small parts to use in your own projects. I thought they were called "macros", but have been unable to find any references or collections by that name. Is there a generic name for this kind of thing, what is it and where could I find more to download?
¹ The original image is 10 times larger.
posted on Mar 16, 2004 - 13 answers