Is there a way to open MS Outlook from an Excel spreadsheet and have the
email message prefill with a generic message and subject  so the user will
simply have to input the recipient's name in the email?

I have a macro - module1 () that we can run it manually.  
Now I want to have the macro run automatically when the workbook open
so I add workbook_open()
--------------------------------

I would like to email a document as an attachment but give the user the
ability to enter in a number that the email will be sent to. Our MS exchange
users are categorized by numbers. For example once the user has completed the
form I would like them to be able to press a button, ...

Trying to write a small app and hit a wall.  I have an Access DB with
a table named PPX.  I have a query named 'SortPPX' stored in  Access
which does nothing more that do a simple sort on 3 fields and a
selection of records.

Sorry if this is a stupid question but I'm having a debug problem.  I
have an error being thrown which states Parameter Not Optional but does
not provide a debug button.  Furthermore, upon clicking OK it does not
highlight anything in the VBA editor.

You'll note that 95% of the code is repeated with just a single
change per section. I simply change the comparator to evaluate
the data 4 times as shown below.

I need to select a range of cells next to an active cell.  My
activecell is named "EmptyCell", but the RC coordinates may change, so
I can't refer to the active cell's RC values.  How do I select the
range starting at ActiveCell.offset(0,1) to ActiveCell.offset(10, 3)  ?

On a worksheet called TestA, I have a combo called 'Player1'
(=EMBED("Forms.ComboBox.1",""))
How do I refer to it's properties from the change event of a control on
another page?

What is the correct way to enter a CSE formula into a range of cells?
   With Sheet1
       .Range("A10:C70").Formula = "=SUM(lARGE(("  ....     etc...    "
   End With

My problem is this:
I have a large database 10 columns * 40,000 Rows.
One of the titles is a code for identifying the other entry's.
I often have a different spreadsheet, where i draw information out of

I have 2 sheets in excel with around 20.000 records each.
I would like to research on "sheet A" if data on "Sheet B" exists.
for that i want to use 3 criteria from sheet B and search in sheet A.
if found, i will do something from sheet B to Sheet A.

I have two columns.  Not all of the values in the first column are in the
second column.  (Some are, some aren't.)
What formula in Excel can I use to say "hey, return the values from the
first column that are not in the second column"?

I'm driving Excel and MySQL on a Mac ...
Might someone point me to a VBA example or a tutorial that uses only
ODBC and not ADO ?
------

In Excel Help, it says that the...Length of cell contents (text) is limited
to 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.
I need to be able to print all contents in a cell.  Is there a way to do

I'm using a change event to run a routine whenever a specific cell (B3)
changes.  That cell uses Excel's data validation tool to restrict the number
of values that can be entered.  The change event macro works fine whenever
the user enters a valid value.  However, it also runs ...