Join 3,501 readers in helping fund MetaFilter (Hide)

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

Help me use Excel to save my job

So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack. I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]
posted by cacofonie on Jun 19, 2014 - 17 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

Spinning, exploding Excel-driven web app: How or should it be?

Sometimes, I am a front-end web developer. Frequently, I meet new people at work who want to turn really complicated Excel documents into dazzlingly interactive web applications. Besides Excel's "Save to Web App" or "Save to SharePoint" features, such people ask if I can tap into an industry to support this -- perhaps scads of agencies and web-based or downloadable tools that make "websites" or at least customizable, interactive reports from Excel spreadsheets, data, and calculations. I'm yet to find this an abundance of examples of this. Are there? If so, what do you call them? [more inside]
posted by metajc on Jan 9, 2013 - 2 answers

Automated PDF modification

Is there an automated way of placing elements from one PDF file into another? Open to coding this via Python if a relevant module exists. [more inside]
posted by mnemonic on Dec 17, 2012 - 4 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

Word I find software that can get to the root of this problem?

How do I obtain a list of all words associated with a list of word roots / stems? [more inside]
posted by hooves on May 13, 2010 - 6 answers

Column-oriented CSV in Python?

Is there a simple, elegant way to iterate over columns in CSV files using Python? [more inside]
posted by Kadin2048 on Jan 11, 2010 - 13 answers

MacgyverFilter: link sharing using MS Office

Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
posted by Monday, stony Monday on Nov 19, 2009 - 7 answers

A Program to Help Me?

I started a new internship, and I'm wondering if there is some way to automate copying the non-profit information from this website. [more inside]
posted by moonroof on Oct 21, 2009 - 6 answers

it's full of tabs?

How do I work with a tab-delimited file when one of the fields is full of tabs? [more inside]
posted by epersonae on Dec 3, 2008 - 20 answers

How to iterate through controls in VBA/Excel?

How do I loop through a bunch of controls using VBA in Excel 2003? [more inside]
posted by apark on Feb 22, 2007 - 4 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

Tracking employee schedules with Excel?

Excel formula question. Using Excel as an employee scheduler and need to help trying to create a formula for tracking. [more inside]
posted by cyniczny on Feb 1, 2005 - 3 answers

Page: 1