30 posts tagged with excel and macro. (View popular tags)
Displaying 1 through 30 of 30. Subscribe:

How to Export All Sheets in an Excel File?

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]
posted by bluefly on Jul 22, 2013 - 2 answers

 

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

Don't select what I selected, select what YOU think you should select!

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]
posted by komara on Jan 2, 2012 - 6 answers

Excel Macros For Dummies

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]
posted by so much modern time on Nov 30, 2011 - 8 answers

Copying contents of cells in Excel

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]
posted by geoffr on May 3, 2011 - 7 answers

There's data just waiting to be scraped....

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]
posted by chrisinseoul on Apr 18, 2011 - 9 answers

Please help me create a mapping macro?

Is to possible to map several addresses from an excel spreadsheet on Google earth, Google maps, etc. using a macro? [more inside]
posted by jefficator on May 13, 2010 - 4 answers

Another GD excel question

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

Need help developing a Excel VBA Macro to Vaildate data entered into a textbox

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

Hide rows in excel if two cells match.

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

How to set Excel2003 to automaticall include file name and path on printed spreadsheets

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

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

Excel can do this, right?

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

Help required for Excel VBA n00b

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 Macro Removal

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

How to repeat a sequence of roughly 40 keyboard clicks in windows 2000 professional to stop insanity

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

Make me a macro...

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

Code Execution has been interrupted

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

Help me figure out how to go about making Excel magic

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 make a DDE connection close in Windows XP?

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

How to get around Excel macro warning.

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

Why is my excel VBA code execution randomly slowing down?

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

Multi line Text-to-column - A CHALLENGE FOR YOU!

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

excel macro n00b

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

Spreadsheet Cleanout

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

Merging Excel Sheets (With a Macro?)

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

Mass Cyrillic to Latin translation in Excel?

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 by michaelkuznet on Sep 1, 2005 - 5 answers

Bibliographies in Excel

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 by synecdoche on May 4, 2005 - 31 answers

Excel for Mac and PivotChart functionality?

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 by AlexReynolds on Jan 13, 2005 - 2 answers

Is there any way to make Excel macros less stupid?

Is there any way to make Excel macros less stupid? [MI] [more inside]
posted by squidlarkin on Jan 5, 2005 - 15 answers

Page: 1