any ideas why when i call "thisworkbook.path" nothing is returned?
like it's null - not even being assigned...
thanks!

I require to write a Macro for Excel that will change a Time to Text.
Such as: '26-Apr -06 08:00' to read '26-Apr-06 Pd 1' instead of Time
(08:00 is period 1 of day)
or '26-Apr -06 08:45' to read '26-Apr -06 Pd 2' instead of Time.

Is there a possibility to rename the worksheet without using the
mouse-rename procedure? I mean using the keyboard only???
Thanks.

I would like to have sheets named after a certain text string in a cell and
refernce them in formulas
For example:
I have a sheet named '123Main' and a sheet named 'Main'

Question:
I've got this formula; =OR(AND(E2-G2>1000;E2-H2>500);(AND(G2=0;H2=0)))
And it works great, the problem is I do not want the true or false
answer but want to personalize it.

Sir,
First I want to thank Mr Max who responded me and tried to solve my problem.
I m also very sorry that I have not good knowledge of English. If someone can
understand my problem and can solve this I will be very grateful. I have a

I have copied and pasted numbers from a source on the internet into a column.
Some appear to be formatted as numbers, some are formatted as text. When I
reformat using Data and Text to Columns to organize them and get rid of extra
spaces, any multiple numbers less than 31 with a ...

I would to assign a unique (sequential) ID # to a cell when that cell is
selected somehow. Once that number is selected then the next time a cell
formatted that way is selected, it gets the next number in the sequence.
Thank you.

Hi... I'm trying to create a timesheet worksheet with the use of functions.
My goal is to extract (Regular, OT 1.5, OT 2, Vacations Days) out of a row
of cells. Below is a sample of my worksheet.
   A B C D E F G H I J K L

Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details.  On one sheet I have a box where you enter th
min and a box where you enter the max.  In another sheet I want

I have a workbook with multiple sheets. I want to have all my Data Lists for
drop down menus on their own seperate worksheet within that workbook. It
says in Excel instructions that it can be done but when I try to do it I get
a pop up that says I can't have my data in a seperate ...

Hi all, i have been given a set of figures (monthly ones) dating back to
Sep 04. i have put them on an excel spreadsheet and createad a line
graph for 17 mths (sep 04 - jan 06). Is there a way using excel to find
a "trend" or "line of best fit" etc. In addition, is there a way for

A few months ago someone posted a similar question about this
situation, but no one replied Thus, I'm really hoping someone may now
have an answer (llama, llama, llama)
HERE Goes: I have Excel 2003. Downloaded the  Excel's add-in 'Template

I copied my .xlb file from one computer to another from a CD.  Apparently,
that made the file read-only.  I keep trying to modify the toolbars on the
second computer, but the changes never stick.  And I can't open the .xlb
file -any time I try, it just opens Personal.xls.  How would ...

I have an excel workbook with a worksheet created by a dump from a
database (DOORS in this case).  The first column is unique, the second
not.  The second column may contain 0 to n identifiers that I want to
look up on a separate sheet.  The lookup is easy when the cell in the