Skip

48 posts tagged with VBA.
Displaying 1 through 48 of 48. Subscribe:

Excel Filter: IF Statements and Concatenate

I'm trying to test if a a series of cells exist, and then concatenate the values that do exist with a paragraph I have. [more inside]
posted by trogdole on Aug 7, 2014 - 10 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

How can I merge bulleted lists in Word spread across multiple files?

Is there a software tool or script for Word (2003 or 2010) that will allow me to combine bulleted lists spread out over multiple files, such that the sub-bullets with the same parent all show up together in one file? [more inside]
posted by ArgentCorvid on Oct 24, 2013 - 2 answers

Outlook and VBA

How to make Outlook automatically change the "From:" field when replying to certain emails? [more inside]
posted by Steely-eyed Missile Man on May 13, 2013 - 5 answers

Assigning a keyboard shortcut to a macro in Access 2007

Is there a simple way to assign a keyboard shortcut to a macro in Access 2007? I understand that macros behave differently in Access than they do in Excel (which I'm more familiar with). I have written a sub called "ImportAll" in Module1. I'd like it to run when I push Ctrl+I. How would I go about achieving this?
posted by Proginoskes on May 10, 2013 - 4 answers

PowerPoint 2010, VBA to copy or create command buttons

I need a macro to check each slide for the existence of several command buttons, and then copy/create them (along with the code behind them) on slides where they're not found. I've tried using the object browser to find the objects/methods to use but, not being very familiar with programming/coding, I haven't been able to figure out how to do it. I tried using a master slide but ran into problems (discussed here: http://www.utteraccess.com/forum/VBA-Import-Slides-Pl-t2002862.html&pid=2355756#entry2355756), but I really need this soon and I'd be happy to run this macro manually whenever I add/import slides. Thanks for your help.
posted by atm on May 4, 2013 - 2 answers

Learning to use VBA

I have read that John Walkenbach's books are the de-facto standard for learning to use VBA in Microsoft Excel. I'd like to know what books are recommended to learn to use vba in other Office products - primarily Access, but also Word and Powerpoint. I'm more interested in books than in websites.
posted by Proginoskes on Apr 6, 2013 - 3 answers

How can I get access to readyState 3 with VBA "AJAX"?

I'm writing some VBA code (in Excel) which uses a reference to Microsoft XML, v6.0, and creates a MSXML2.XMLHTTP object. I used the clsXMLHttpMonitor example from this page as a starting-off point. How can I access the response text when readyState = 3? [more inside]
posted by jozxyqk on Jan 8, 2013 - 10 answers

Help this Mac user learn PC software for job hunt

How can I improve my computer skills for job hunt when I use a Mac and the software is for PC? [more inside]
posted by hrj on Aug 9, 2012 - 24 answers

How to automate a dynamic web page using VBA?

Help me automate some of my work involving taking values in a spreadsheet and plugging them into a website with dynamically generated content. [more inside]
posted by Reverend John on May 9, 2012 - 6 answers

Method Range of Object Global failed

I'm starting to write some Excel-VBA Macros, but it seems I don't get some basic things. I tried this simple code: [more inside]
posted by SweetLiesOfBokonon on May 2, 2012 - 4 answers

Need VBA help to refresh and save worksheet.

Have Excel 2007. I would like to have a spreadsheet perform the following simple? tasks [more inside]
posted by bleucube on Apr 22, 2012 - 3 answers

Please use small words not written in VBA

Conditional Images in Word. It must be possible, but how hard is it, and am I just looking in all the wrong places for an answer? [more inside]
posted by instead of three wishes on Feb 17, 2012 - 7 answers

How do I set up Auto BCC on a single Exchange account out of three, in Outlook 2010?

I need to Auto BCC myself on all mail I send through Outlook 2010 from one (and only one) of my Exchange accounts. How can I do this? [more inside]
posted by zarq on Jan 2, 2012 - 2 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

Best practice in implementing a two-part unique identifier?

Best way to implement a two-part unique identifier in Access? [more inside]
posted by jsturgill on May 9, 2011 - 14 answers

VBAin't working

VBA for Word help. A lot of help. I'm trying to find a string, then search and replace a space within that string. I can do parts of this, but not the whole thing and not for the whole document at once. [more inside]
posted by theredpen on Dec 21, 2010 - 13 answers

Programs to learn on?

I'd like some program ideas to implement. [more inside]
posted by jsturgill on Aug 22, 2010 - 11 answers

Who can help me with this?

Where is the best place to look for help with Access? I like and trust the answers I get on AskMetafilter but they are expensive (1 per week etc.) I have a programming question that I need help thinking through. [more inside]
posted by amethysts on May 21, 2010 - 6 answers

Trying to find Excel VBA code for "round dot" gridline.

Excel VBA question: help me insert a "round dot" gridline in my chart. [more inside]
posted by mullacc on Apr 18, 2010 - 8 answers

Using Excel to create the body of an Outlook e-mail

Complex Excel question - need to select a range of cells, based on the selection of a separate cell. But wait, it's more complicated than that! [more inside]
posted by doh ray mii on Feb 24, 2010 - 1 answer

VBA Moron Wants Magic Bullet

Access 2007: Need code to grab the value _displayed_ in a combo box (as opposed to its actual value). Big, detailed explanation inside. [more inside]
posted by Ys on Feb 20, 2010 - 5 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

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

MS Outlook: scheduling VBA scripts?

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

Excel solver macro help.

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

Know any good VBA tutorials?

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

Excel Programming Book

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

You better C sharp or you'll VB flat

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

Stupid Outlook! No cookie!

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

Selecting range of data based on values in a particular column

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

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

Excel Macro

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

Can Automator Do This

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

Cruel by inevitable extinction of Excel monkeys

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

Stumped by VBA-ising an array formula in Excel

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

Turning a complex Excel spreadsheet with VBA functions into an online app

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

Decimal seconds, please.

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

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

Excel Sheet Lockout

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

Word Macros: Put your right footer in, take your right footer out...

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

Problems creating a popup keypad in access.

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

Oh. My. Code. Excel VBA Needs

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

Why does VBA use 12/30/1899 for zero?

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

Instancing a Microsoft Access form

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

Sending email according to a schedule.

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

Page: 1
Posts