Trying to open Excel fom a command button on an Access form to retrieve and
process data to produce charts.
If I open Excel directly everything is fine without the Stop instruction
If I open Excel by pushing the button on the Access form the data  loads OK

 I have a working VBA add-in for Excel that needs to support Excel versions
2000-2007.  Since Excel 2007 makes use of a different menu system I will need
to create two different interfaces (one for Excel 2000-2003 and one for
2007).  I would like to try to re-use as much code as ...

My client makes extensive use of long CHOOSE formulas that references cells
in another large workbook.  They are constantly using these CHOOSE formulas
for buliding "reports" in dozens of workbooks.  I am concerned that any
changes to the structure of the large source workbook ...

Does anyone know of an event that will run as soon as the user has used the
autofilter please

So right now this code will create an email then put a .htm file into
the body of the email.  What I want to be able to do is have more than
one (maybe even three or four) .htm file(s) to be added to the body
(back to back to just look like a longer email).  Does anyone know how

i am trying to set up drop down menu to select other drop down menus ie :-
main drop down=alpha, numeric,roman, sub drop down menu's (a,b,c etc),(1,2,3
etc), (I,II,III etc)

I am trying to determine the best way to hide rows based on a certain
criterial.  In sheet 1 of my model, I have a column of cells E63:E102
with formulas that either equal zero, or a value greater than zero. I
would like to hide the rows where the value is equal to zero. I have

Hi.  I am new to VBA and am attempting to copy multiple ranges found in
worksheet "SubjID" to a Summary Data Sheet.  I found the following code
online (I included the form frmSubjIDPrompt - simply goes to the SubjID
worksheet that the user inputs).  I keep getting the error "Type ...

I’m trying to come up with a macro that takes names in a list, Range is
AA1:AA11, copy paste each name into both Range A3:A6 and Range A11:A14.  
Several links, all using GetPivotTable functions, will update with the name
in those ranges.  Then I want to copy/paste the Range A1 ...

From VBA I want to write a date into a file a file in the format
YYYY.MM.DD
how can I do this?
Lars

I have two columns: Column A for a series of account numbers for each asset
comprising it; the second, Column B holding dollar values.
In each column, each account is separated from the next by a row where
Column A has "Sub Account Number" and Column B has "Market Value".

Got some code in an Excel workbook.
User plans to save multiple copies of workbook.
The Good-Right-And-Holy-Path seems pretty clear: move said code to
a .XLA so any changes to same will be transparent across copies of the

I have multiple sheets all running code. However, there are times when I
would rather call a sub from another worksheet instead of duplicating the
code.
I used Call SubName to call it from the active sheet. What is the syntax for

I wanted to shorten the macro-made format code:
I used this hoping to shorten the amount of code needed to format the cells,
but it gives me a type mismatch. I am also hoping to use Arrays with text in
them for many other areas of my code. Is this possible?

I am returning to programming after a few years I was pretty proficient in
excel 2003 and when I finished I was aware that 2003 code often didn't run
in 2007 for some trivial reasons (rounded corners didn't work I recall). Can
anyone give me an opinion on the ease with which ...