With a macro in a file open an other file and copy cells.
This works in excel 2003 but not in 2007 what's wrong?
I use new file .xlsm error code 9
   macro in file name.xlsm

I am trying to use a VBA program to place a Icon in the Menu Bar.
Used Recorder and copyed into a macro, which place an invisiable incon
in the Menu Bar.  Would like to see the Icon to, be a happy face with
text or just text.  Can you help me?

I'm trying to extract a 15 digit number from a long text string within
cells.
Many of the cells in my spreadsheet have lots of text, with sometimes
200-300 words per cell. Each of these cells has one15 digit number

I have a challenging problem to solve in excel. Below is the basic
data with row numbers and column letters. Cells are separated by
spaces. Note that the real data are 100's of rows long.
        A      B      C

Say the date that a certain event occurs (2/17/07) is in cell A1.
I would like to have cell B1 display: Completed 2/17/07
If I use the formula ="Completed "&A1, it displays: Completed 39130
Is there another way to do this?

if i want to create relation between two cells to give number in third cell
for instance i want B6=10 if A6=5 & C6=15 simulatenously

I have a spread sheet that shows many rows.  I want to have a totals row at
the bottom.  Is there a way to have a row that automatically shows at the
bottom of the shread sheet?  I know how to create this at the bottom but
others in the office are not comfortable with inserting ...

Say I have 120 bowling players, their id_number in col_a,
they all have different skill level, indicated by his avg_score in col_b
I need to allot them into n teams (say 15), of equivalent strength on the
TEAM level

Hi -  I want to be able to have a row of cells to be a header row for each
page - I want this row of cells to align with the column..
I looked at the Header feature but it did not allign with the cells...
How do I get a row header (aligned with the cell columns) to print out for

Is there any simply way to use excel to keep Inventory purchases,
sales, adjustments
and Balances ?      I like to be frank, I am asking this because I
cannot afford to buy commercial  versions.

Given the equation of a circle (or some derivative), how can I draw a
circle (1 or more) in an XY chart using Excel 2003?
Thanks!
Hank

Issue #1:  (Row height)  I always want my row height to be 20.0, but Excel
97 at work is set by default to 12.75, and the Excel 2003 at home is at
13.5.   Am I stuck with that?  Do I *always* have to manually change to 20,
or is there some way I can change the default height to ...

Hi to all,
Sheet1 has a value in cell G14 represent the years of a date
I want to copy it to sheet3 in th same location G14 but only to display 2
digits (1993 will show as 93) and 2007 will show 07 and 2000 will show 00)

I apologise cause of my lack of knowledge to do this.
I have 2 questions
1) I need to copy all my excel files to a pen drive or CD.  so, i
searched them by using

I'm new to excel, perhaps someone will help me.
What I want to do is to make a monthly expences list. At the moment got sth
like this:
FEBRUARY