Create a macro to convert multiple .txt file and place all data from text to .xls file

1. Convert multiple .txt files in a folder
2. Delimit the .txt files so that there are headers in each column
3. Format for date (1st column) should be in DD-MM-YY format
4. Place all data from .txt files into 1 .xls file
5. Scan through the data in .xls file
6. Ensure all data are unique (ie. no repeated data in each row)

Error in Renaming Folder in Windows Explorer

Rename a folder but the error states :

Cannot rename ____ : Access is denied.
Make sure the disk is not full or write-protected and that the file is not currently in use.

However, owner is under my name and I have full rights to the folder.
The files in the folder are not even opened.

How ? 

Comparing sets of data (lower and upper limit)

Data set:
0.5, 1.5, 2.1, 0.43, 0.35

condition/base number : 1

Result needed:
To select number nearest to 1 ie.= 0.5 by using macro.

Note: Although 1.5 is also near to 1 (also a 0.5 difference), it must choose the smaller number.
(0.5 is smaller as compared to 1.5) 

Random Variables and Probability Distribution

Question 3.32

The proportion of the budgets for a certain type of industrial company that is allocated to environmental and pollution control is coming under scrutiny. A data collection project determines that the distribution of these proportions is given by:

f (y) = 5 (1-y)^4,  0<=y<=1
          0, elsewhere

a) Verify that the above is a valid density
b) What is the probability that a company chosen at random expends less than 10% of its budget on environmental and pollution controls ?
c) What is the probability that a company selected at random spends more than 50% on environmental and pollution control ?

How do I extract selected text from a string of text?

Data in a cell and need to extract part of it :


Examples:
1. AERO 030405A AUTO 24567AZ 99AM  > Extract 67
2. AERO 030405Z AUTO 25611C22AZ 99BM >  Extract 11 

AS400 / DB2 Programming Tutorial Guide

My favourite guides are :

Tutorial for AS400
http://www.texas400.com/tutas400toc.html


Tutorial/book on DB2
http://publib.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/CCONTENTS

Let me know if you have more to share. 
I am still learning -__-

Probability

Question 2.26

A California study concluded that by following 7 simple health rules a man's life can be extended by 11 years n the average and a woman's life by 7 years. These 7 rules are as follows: no smoking, regular exercise, use alcohol moderately, get 7-8 hours of sleep, maintain proper weight, eat breakfast, and do not eat between meals. In how many ways can a person adopt five of these rules to follow
a) If the person presently violates all 7 rules?
b) If the person never drinks and always eats breakfast?