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
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
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
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
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
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
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
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
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
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
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
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
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
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 anyone recommend a good book for medium-advanced level vba programming for Excel?
posted by Miss Otis' Egrets
on Aug 4, 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
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 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
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
