Sub test()
' I want to creat a folder if that folder doesn't exist in the path.
' The following statement is not supported. What is the right way?, Please.
If Not Application.exist("I:\Mybackup\") Then MkDir ("I:\Mybackup\")

How can I assignate to a number à color?
Exemple 1=green; 2=red; 3= bleu

In Germany, the words false / true (falsch / wahr), based from checkboxes,
are written in lower case letters, and Excel doesn't 'read' it as a boolean.
When I doubleclick on the cells "Falsch" and "Wahr" and then press enter,
the word changes the notation to capital letters. (e.g. ...

Good Morning -
I am having problems creating a dropdown list.  I have followed the
directions but it is not working for me.  Can someone please help.
Thanks,

Dear Sir
Lets consider  the following raw data
Raw Data
Staff     Code       Month       Amount

Dear Sir,
When VLOOKUP formula fails to find the perfect match it always return with
#N/A.
Usually #N/A disable me to do any computation that involve that cell. The

I have 2 sheets.  Sheet #1(Terminted Employees) has employee ids, names,
termination date, etc.  Sheet#2 (New Hires) has employee ids, names, hire
date, etc.  I will like to compare the dates in the 2 sheets.  I need a
formula that will look at the termination date and the hire ...

Hello everybody, I just want to ask how to protect our worksheet.  I mean if
somebody who open my worksheet,  he/she can read only. They can't change or
save the worksheet.
thanks

When I open an Excel worksheet, the file is *always* stretched out so that I
cannot see the vertical or horizontal scroll bars.  I have to move the file
over bit by bit, until I reach the upper right corner (where I can see the
vertical scroll bar), then scrunch the file down ...

does anyone know how I can reduce the file size of an excel workbook?  I
have been working with this file for a year- it has always been under 5MB -
all of a sudden the last 2 or 3 times I have worked on it and saved it - it
has gone to 21MB (and I can't figure out why) !! Now I ...

Hi,
I get info coming in that is formatted :-
08-Aug    02:42                   
08-Aug    07:29    08:10    09:58    10:45    11:58    13:33

I need to write an if statement that says in non formula terms,
if CELL A1 = 123, do vlookup etc
or if CELL A1 = 456 do vlookup
or of CELL A1 = 789 do vlookup

I have 15 worksheets which I would like to print with the worksheet tab in
the bottom right hand corner.  I Grouped all the worksheets and then clicked
print entire workbook and clicked on Footers and click on worksheet tab.
The worksheet tab only appears as a footer only in the ...

I have a list that contains a field for road number.  It sorts like the left
column, but I want it to look like the right column:
Road Number      Road Number
2                          1A

I am using Excel 2000.  When I double click on a file name in Windows
Explorer I get an error message that the file cannot be found.  However, when
I click on Open in Excel and find the file I CAN open it.  This is more of a
pain in the neck than a critical issue, but I would ...