I have a DATA.CSV file with numerical data.  I wish to view this data, using
a chart and macro which is located in a different COIL_VIEWER.XLS excel
file.
Is there a way to open the DATA.CSV  file, and automatically execute the

I inhereted an Excel spreadsheet from a previous employee.  The VBA is
password protected.  Does anyone know a way around the password?  I would
HATE to re-create the entire sheet.

Is there a text function that returns a specified range within a cell
reference?
for instance given the below conditions, i'd like a1 to return "yahoo"
(characeters 12 through 16 of cell b1) and have the hyperlink show up

This is a follow up from a previous post.  When opening  a specific file with
excel 2003, Excel will immediately shut down.  When I re-open Excel it shows
the file in the recovery box. When trying to recover the file it gives a
message that file damage is too extensive to repair. ...

Can anyone tell me why this may be happening and how I can fix it?  Take a
look at the screenshow below:
http://home.comcast.net/~jvelite/formatError.JPG
This is a screenshot of excel in Print-Preview mode.  As you can see the

I am trying to get a validation list from another sheet in the same file, is
this possible?.
Thanks
Fernando

I have a spread sheet where I need to fill in days that I was at work, we
put an X in the field if we were here. This would mean no X for Saturday or
Sunday. What I want to do is have the ability to put the beginning pay
period date in a field, and have the spread sheet place the X ...

Function Celsius(dFahrenheit As Double) As Double
   Celsius = (dFahrenheit - 32) * (5 / 9)
End Function
As a demo, I have been trying to get a simple VBA function to work

I'm trying to view all the tabs of a workbook by selecting:
File | Print | Print What: Entire Workbook | Preview
but when i choose "Entire Workbook", the Preview button is dimmed and I
cannot select it.

Good Morning All,
Using Windows XP & Excel XP
I have a worksheet that displays a daily 3 digit lottery number with the 3
digits being separted in column A2, B2 & C2

I am currently filtering a list using the Autofilter function within
Excel. Great! However, I would like to produce a Summary Report in a
seperate worksheet based on the results of the filter.  Does anyone
know a method of how to obtain criteria on which the Autofilter is

I'm having a fun time with Excel 2000, merged cells and row heights!  I have
a worksheet with rows of merged cells that span 14 columns.  Text is entered
into these merged cells and it often wraps to multiple lines.  When I try to
use the Format -> Row -> Autofit function it ...

I want to do a Trim on non-formula cells in specific columns.  Currently the
Trim macro (which works, but is slow because of hitting all cells), looks
like this:-
Sub Trim_Text()

I currently work in a Installation Access Office for the Military and need to
link different files to condence my work load. I do simple data entry on one
file but must check on another excel file to see if they been barred from
post. Futher more we generally have data on most ...

I put the following in the Workbook_Open sub of a workbook.
ActiveWindow.Caption = ActiveWorkbook.FullName
It works just fine for that workbook but I really want it to work for
any workbook I open so I tried putting it in the Workbook_open sub of