Can I launch a program (.exe) from inside an excel macro? Excel 97.

how do I send an excel spreadsheet as attachment with only the created
document so that the outer/surrounding un-used columns and rolls do not
appear in the attachment?

In an Excel file two AddIns are used. These are the "Analysis Functions" and
"Analysis Functions - VBA" AddIns (maybe wrong name, translated from
German).
If the Excel file is opened by the user directly, anything works fine.

I want to have something like this in an Excel macro but I don't know how to
write it in VB:
For each val in ("value1", "value2", "value3")
 ----statements

Thanks for your help in advance.
Have cells containing various dates, Ex. 070306. Data in these cells copied
from a WORD Doc.
Want dates display as follows:  07/03/2006.

Greetings VBA experts.
After a couple hours of attempts, I've gotten close but have no cigar.
I'm trying to make it so that a user enters a value (text) in a particular
cell (let's say F3), then clicks one of two buttons (a PLUS button or MINUS

How to change from inches to mm in Excel?

Somehow I'm having trouble changing case in a spreadsheet. I brought up help
but I'm missing something. I want to change everything to upper case. Help

is there a way to arrange worksheets in alphabetical order?

How do I get rid of this error message from my cell -#Value!.  I have a cell
C1 which has a number for example 500 and C2 I have XXX in the cell and C3 I
used this formula =C1-C2, but I get the #Value! error message.  What is
funny about this is on one worksheet cell C3 returns ...

At least it is to me - now I humbly beseech your magic :)
A1 to A10 contain 10 unique letters, e.g. A,Q,E...
B1 to B10 contain 10 unique letters, e.g. Z,B,A...
C1 to C100 contain nonunique letters, e.g. E,E,F,E,Q,Q...

In one column I will have a variety of letters.  (A, B, C etc)  In another
cell I want to have the sum of all the A's in that column.  In a different
cell I want to have the number of B's in the column - and so on. How do I do
this?

I get this output from my checsum calculatios FEF01. I would like to
trim the output to 4 digits to look like a more conventional checksum.
ie EFO1. Any way to mask out the lower 4 digits?

MACRO --- I have:
NewFileNumber = Application.GetOpenFilename(FileFilter:="All Files
(*.*),*.*", Title:="Select a HEX file to import")
Open NewFileNumber For Input As #1

How can I get to page setup in excel 2007?  They have hidden all the !$%&&@!!
useful feature.  
All I want to do is set my row at the top and print like I have been doing
for the last 10 years.  Any thoughts on where / how you do this in excel 2007?