Dennis

Bob's docprops function is a user defined function(UDF), not a native Excel
function.

Must be copied into a general module in your workbook.

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project and select it.

Right-click and InsertModule. Paste the above code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Enter the formula in a cell as =docprops("creation date")


Gord Dibben Excel MVP

On Mon, 28 Nov 2005 13:40:02 -0800, DENNIS (NOSPAM)
wrote:

Thanks Bob , i am an Excel rookie. I tried the =docprops() function and got a
#name error response, does this mean its not installed in my version?