I have the following in a spreadsheet:
A    B    C    D    E    F    G    H
row 1    1.1    1    76    71    #N/A    71    5
row 2    1.2    1    124    117    #N/A    117    7

I have prepared a spreadsheet that has a macro(recorded) in it that when
invoked, opens another excel file.
Here is that code:
Workbooks.Open Filename:= _

I was wondering if anyone could help me. I have seen a few examples
that are fairly close to what I'm looking for.
I'm wanting to look at a range of data in a column and find all the
cells that have a value not equal to 0, then move it one column to the

Excel 2003 -- header row sorting
I have a coworker using Excel 2003 that has a shared workbook. Everytime she
sorts the data she has to select header row so it doesn't default to header
row instead to no header. How do I fix this? (when I open the workbook and

I have numerous sheets within a book where all cells in column C in all
sheets have the following formula “=IF(ISBLANK(P4),"",(R3-P4))”. For you
reference both columns P and R hold a monetary value and are formatted as
Currency.

I am using: =sheet1!=A1 to show information on sheet2 A1.
The data shows up fine, the format does not.
For example, Sheet1 A1 is Times New Roman 10pt.
Sheet2 A1 shows Times New Roman 10pt.

I am writing a program.
I have a excel range object.
And I want to point another cell at this range.
how can I do that?

I am looking for some excel template for production planning purpose
(master producton scheduling).  Anybody could help to provide it ??

I'm trying to work out this problem, and wanted to see if others have
come up with a solution.
What I have is a pivot table report in Excel 2007, which shows a pay
period and amounts paid in overtime for each employee.  The list is

Which is the fastest way to compare the strings below,
the following way:
Each of MyStrings shall be compared for the quantity of N 1's  vs all of
the Main strings on the same position!

I seem to remember reading somewhere that there is a limit to the amount of
memory that Excel can use, even if you have much more RAM available is the
computer.
For example, if your computer has 512 mb of RAM, an Excel workbook might be

Excel 2007 crashed.  Funny, the dialog box gave choices "send later" and
"don't send" which seemed odd to me (as i am used to "send now" and "don't
send").  I said "send later".  Then, i got an alert, "Excel is recovering
your documents".  However, Excel did not automatically ...

I have got an error: "OLE ERROR 80030003" when using EXCEL Template?
The template and result file also store in our server.
Server: 2003
Client: WinXP+ Office03

I have a workbook with multiple sheets that have similar datasets on
them. I'm trying to create a summary sheet that adds up the value of
the cells across the sheets and lists them on one sheet. I have
created a list of all the sheets I want to include (and have created a

I have got an error: "OLE ERROR 80030003" when using EXCEL Template?
The template and result file also store in our server.
Server: 2003
Client: WinXP+ Office03