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

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

Using Outlook 2007 on windows XP, how do I run a (VBA) script either daily, or on opening the application? [more inside]
posted by pompomtom on Nov 10, 2009 - 4 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

Can you reccommend VBA tutorials, particularly for MS Excel 2007? [more inside]
posted by Librarygeek on Oct 19, 2009 - 1 answer

Can anyone recommend a good book for medium-advanced level vba programming for Excel?
posted by Miss Otis' Egrets on Aug 4, 2009 - 0 answers

How do you use a Class Library DLL created with C# from VBA? [more inside]
posted by jozxyqk on Jul 1, 2009 - 1 answer

VBA programmers: is there any way to control the formatting of Outlook Contacts Body text? [more inside]
posted by IAmBroom on Feb 2, 2009 - 0 answers

ExcelFilter: How can I select a range of data using VBA in Excel based on the values in a particular column? [more inside]
posted by squorch on Jan 29, 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

Using Excel VBA, how to convert positive numbers to negative, and vice versa? [more inside]
posted by yezimary on Jan 7, 2009 - 16 answers

I want Leopard's Automator to do something seemingly simple, but can't get it to work. Can anyone help? [more inside]
posted by crapples on Nov 26, 2008 - 8 answers

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

What to do about the inevitable irrelevance of my skill set? [more inside]
posted by anonymous on Nov 3, 2008 - 11 answers

How to do a VBA version of the following array formula in Excel? The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA: {="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)} [more inside]
posted by Mokusatsu on Oct 17, 2008 - 3 answers

I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA? [more inside]
posted by Mokusatsu on Sep 12, 2008 - 2 answers

Microsoft Excel VBA question: Converting decimal degrees to degrees-minutes-seconds (DMS), with rounding customization. [more inside]
posted by dondiego87 on Jun 10, 2008 - 5 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

I have a spreadsheet that I want to lock after a certain amount of data is entered. It needs to be an auto lockout as I cannot count on the user to stop entering data after a certain point. MI [more inside]
posted by lampshade on Nov 23, 2007 - 2 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

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

I am developing an access app for a UMPC, and because of the lack of a keyboard, I want to make a keypad number entry popup. [more inside]
posted by JonnyRotten on Oct 31, 2006 - 5 answers

I've created a button in Excel 2002 that runs some VBA when clicked. Works great. I've emailed the spreadsheet home and opened it with Excel 97 and clicking does nothing. When I run the subroutine from VBA editor, it works fine. So, what gives? Why won't this work in Excel 97 and what can I change so that it will run in Excel 97 and beyond? I've pasted the subroutine into the Extended box. Oh, and I'm really an infant with this, so please try and communicate on that level. [more inside]
posted by kc0dxh on Sep 8, 2006 - 11 answers

In Microsoft VBA, the zero value for dates is midnight 12/30/1899. Does anyone know why that particular date/time was chosen for zero?
posted by jasper411 on Nov 13, 2005 - 7 answers

I'm stuck instancing a Microsoft Access form. According to Litwin, Getz and Gilbert (Ch 8), the statement 'Set frm = New Form_frmMyForm' should create a new instance of frmMyForm, referenced via the 'frm' variable. However, when I try this I get a compile error "User-defined type not defined", and it highlights the code 'New frmMyForm'. [more inside]
posted by Ritchie on Feb 20, 2005 - 6 answers

I've just taken over an email list which sends a single message to a single address which then goes to hundreds of people once a day, Monday through Friday. I have the info to be sent in a randomized Excel file. Using that file and Outlook's delayed sending feature, I want to preload all the messages for the next year. I found some VBA scripts to do similar things, but my hacking skills aren't up to modifying them, particularly when trying to set them to send for a future date. Do you have any suggestions for premade scripts or software to do this? I want to set it up, run it, and forget it, not leave it open to run every day.
posted by Mo Nickels on Jul 27, 2004 - 2 answers