Need help developing a Excel VBA Macro to Vaildate data entered into a textbox [more inside]
posted by complience on Nov 25, 2009 - 4 answers

Please help me create an excel macro to hide rows given a certain criteria. [more inside]
posted by onich on Nov 17, 2009 - 9 answers

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]
posted by Lucubrator on Nov 1, 2009 - 3 answers

How can I set up Excel 2003 to automatically include the file name and path on every spreadsheet when printed? [more inside]
posted by Wroksie on Oct 20, 2009 - 7 answers

Simple problem: record a macro and play it back in firefox. Hard part: recording a macro and playing it back in firefox. [more inside]
posted by TomMelee on Oct 19, 2009 - 9 answers

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

I am in a market for a Windows macro recorder and am trying to decided between Perfect Macro Recorder or Jitbit or whatever HIVEMIND suggests... [more inside]
posted by tcv on Aug 20, 2009 - 2 answers

Can I set up an Excel spreadsheet so the user is presented with a series of fields, like a form, instead of having to enter data directly into the cell? [I'm having a hard time even wording this question properly, so I haven't been able to find the answer anywhere. I turn to AskMe. Further explanation follows...] [more inside]
posted by The Deej on Aug 11, 2009 - 14 answers

Is it possible to have a web browser plugin/macro that will untick boxes on a webpage by default? [more inside]
posted by a womble is an active kind of sloth on Aug 4, 2009 - 6 answers

ExcelMacroFilter: Writing a macro that imports a series of .csv files into their own worksheets in the same workbook in Excel 2007 would save me ridiculous amounts of time. I have written a macro to import the files and rename the worksheet accordingly, but I'm new to VBA and can't for the life of me work out how to get Excel to automatically repeat the import from File_1.csv to File_x.csv. Help please? [more inside]
posted by cholly on Jul 30, 2009 - 4 answers

Excel 2003 says I have macros in one workbook. I want to delete them, but Excel won't let me. NeoOffice (for the Mac) also won't let me. When I look for them using the Macro Dialog box or the VB editor, I can't find them. Can I delete these macros, or do I have a serious problem? [more inside]
posted by CancerMan on Jul 10, 2009 - 9 answers

I'm using Windows 2000 professional. I'm copying data from excel to the forms on separate pages of a website, and have to repeat a string of keyboard controls several times. Is there an application I can download to do this automatically? Does the computer come with a tool that allows you you type a series of keys into the computer, then just "repeat" 83 times? [more inside]
posted by omnigut on Jun 16, 2009 - 9 answers

ExcelMacroFilter: Am I screwed? I need a macro in a pre-formatted Excel template that will open the Open File dialog box and then, once a file is opened will copy/Paste Special...Values into the template. [more inside]
posted by bluejayway on May 29, 2009 - 12 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

Outlook Macro Filter: I'm limping my way through creating VBA macro for use in OL07. Be my crutch. [more inside]
posted by tdischino on Mar 31, 2009 - 3 answers

Code Execution has been interrupted:
Continue - End - Debug - Help
*Click Continue*

*Repeat Indefinitely*
Help?! [more inside]
posted by johnstein on Jan 19, 2009 - 6 answers

Photographing shiny things: help my light this stuff nicely and take a good photo that isn't blurry. [more inside]
posted by ninazer0 on Jan 7, 2009 - 13 answers

How can I have Excel generate a new column with the data I need using certain conditions and pulling data from a pivot table? [more inside]
posted by ttyn on Jan 6, 2009 - 5 answers

How can I close DDE connections? [more inside]
posted by slavlin on Dec 18, 2008 - 1 answer

I'm looking for a digital camera to copy books and such for onscreen presentations. Not spending a lot would be nice. [more inside]
posted by cccorlew on Dec 8, 2008 - 5 answers

I have been asked to convert some Word Perfect Macros to Open Office, and am looking for any ideas, or resources would help with it. Any thoughts on how you were able to complete the task would be great. [more inside]
posted by Amby72 on Nov 20, 2008 - 1 answer

Word 2007. Table with cells with lots of text. Need to convert asterisks to bulleted lists. Example inside. [more inside]
posted by limon on Nov 5, 2008 - 2 answers

How to bypass Excel macro warning or alternative to macro. [more inside]
posted by emjay on Nov 4, 2008 - 13 answers

I know about lolcats. I know about loldogs. What I want are some other different lolanimals. [more inside]
posted by Solomon on Oct 30, 2008 - 25 answers

How can I use the iPhone 3G's headphone jack to power an LED? [more inside]
posted by buzzbash on Oct 19, 2008 - 8 answers

I'm looking for a way for a macro program (RoboTask is the one I'm currently using) to tell whether or not a streaming video has completed playing. I think the best way to do this would be to monitor the current download rate to my PC, and when it drops to 0 kb/s for a second or longer, then trigger the video completion event. I have no idea how to do this, however. [more inside]
posted by idyllhands on Oct 8, 2008 - 2 answers

How do I make a macro for Microsoft Word to capitalize lines in an interview? [more inside]
posted by perpetualstroll on Sep 1, 2008 - 3 answers

Sometimes excel VBA code executes very slow. Sometimes it's really fast. I can't seem to pinpoint why. [more inside]
posted by johnstein 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 by sararah 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 by bokane on Mar 30, 2008 - 5 answers

Photography filter: Next step up from "digital macro"? [more inside]
posted by colecovizion 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 by abkadefgee on Mar 18, 2008 - 6 answers

How to "text to column" a cell with multiple lines in Excel? [more inside]
posted by keasby 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 by Don-da-lah on Dec 30, 2007 - 18 answers

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

How do I get (and keep) lowercase cross-references in Word 2002/XP? [more inside]
posted by mnsc 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 by dead_ 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 by backwards guitar 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 by Merdryn on Jul 28, 2007 - 1 answer

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 by jacksides on Jul 23, 2007 - 9 answers

Ugh. I Can't believe i'm asking a (probably) stooopid ipod question-filter... [more inside]
posted by Izzmeister 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 by beammeup4 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 by Salmonberry on Apr 27, 2007 - 3 answers

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

Can you help me find a particular Photoshop tutorial that I saw a while back? [more inside]
posted by braintoast 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 by dorcas 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 by TomMelee 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 by moocheen 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 by chrisamiller on Dec 27, 2006 - 3 answers

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