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