Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES IN EXCELL
IS THERE ANY WAY TO MAKE AN EXCELL WORKSHEET SHOW THE DATE IT WAS ORIGIONALLY
CREATED AT THE TOP OF THE PAGE ? I KNOW HOW TO USE =TODAY AND =NOW FUNCTIONS BUT THESE RESET THE DATE AND TIME EACH TIME THE SHEET IS SAVED OR MODIFIED. I NEED TO SHOW THE DATE OF CREATION AS WELL AS THE LAST DATE OF MODIFICATION ON MY WORKSHEET. I USE EXCEL TO PREPARE MATERIAL LISTS IN CONSTRUCTION ESTIMATION. ANY HELP WILL BE GREAT. THANKS -- DENNIS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES IN EXCELL
dennis, your caps key must be stuck
-- Don Guillett SalesAid Software "DENNIS" (NOSPAM) wrote in message ... IS THERE ANY WAY TO MAKE AN EXCELL WORKSHEET SHOW THE DATE IT WAS ORIGIONALLY CREATED AT THE TOP OF THE PAGE ? I KNOW HOW TO USE =TODAY AND =NOW FUNCTIONS BUT THESE RESET THE DATE AND TIME EACH TIME THE SHEET IS SAVED OR MODIFIED. I NEED TO SHOW THE DATE OF CREATION AS WELL AS THE LAST DATE OF MODIFICATION ON MY WORKSHEET. I USE EXCEL TO PREPARE MATERIAL LISTS IN CONSTRUCTION ESTIMATION. ANY HELP WILL BE GREAT. THANKS -- DENNIS |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES IN EXCELL
'----------------------------------------------------------------- Function DocProps(prop As String) '----------------------------------------------------------------- Application.Volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocument*Properties _ (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function and enter in a cell such as =DocProps ("creation date") -- HTH RP (remove nothere from the email address if mailing direct) "DENNIS" (NOSPAM) wrote in message ... IS THERE ANY WAY TO MAKE AN EXCELL WORKSHEET SHOW THE DATE IT WAS ORIGIONALLY CREATED AT THE TOP OF THE PAGE ? I KNOW HOW TO USE =TODAY AND =NOW FUNCTIONS BUT THESE RESET THE DATE AND TIME EACH TIME THE SHEET IS SAVED OR MODIFIED. I NEED TO SHOW THE DATE OF CREATION AS WELL AS THE LAST DATE OF MODIFICATION ON MY WORKSHEET. I USE EXCEL TO PREPARE MATERIAL LISTS IN CONSTRUCTION ESTIMATION. ANY HELP WILL BE GREAT. THANKS -- DENNIS |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES IN EXCELL
Sorry bad work habit. Our POS sales system only recognizes caps. Any thoughts
on my problem? thanks Dennis "Don Guillett" wrote: dennis, your caps key must be stuck -- Don Guillett SalesAid Software "DENNIS" (NOSPAM) wrote in message ... IS THERE ANY WAY TO MAKE AN EXCELL WORKSHEET SHOW THE DATE IT WAS ORIGIONALLY CREATED AT THE TOP OF THE PAGE ? I KNOW HOW TO USE =TODAY AND =NOW FUNCTIONS BUT THESE RESET THE DATE AND TIME EACH TIME THE SHEET IS SAVED OR MODIFIED. I NEED TO SHOW THE DATE OF CREATION AS WELL AS THE LAST DATE OF MODIFICATION ON MY WORKSHEET. I USE EXCEL TO PREPARE MATERIAL LISTS IN CONSTRUCTION ESTIMATION. ANY HELP WILL BE GREAT. THANKS -- DENNIS |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES IN EXCELL
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? -- Dennis "Bob Phillips" wrote: '----------------------------------------------------------------- Function DocProps(prop As String) '----------------------------------------------------------------- Application.Volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentĀ*Properties _ (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function and enter in a cell such as =DocProps ("creation date") -- HTH RP (remove nothere from the email address if mailing direct) "DENNIS" (NOSPAM) wrote in message ... IS THERE ANY WAY TO MAKE AN EXCELL WORKSHEET SHOW THE DATE IT WAS ORIGIONALLY CREATED AT THE TOP OF THE PAGE ? I KNOW HOW TO USE =TODAY AND =NOW FUNCTIONS BUT THESE RESET THE DATE AND TIME EACH TIME THE SHEET IS SAVED OR MODIFIED. I NEED TO SHOW THE DATE OF CREATION AS WELL AS THE LAST DATE OF MODIFICATION ON MY WORKSHEET. I USE EXCEL TO PREPARE MATERIAL LISTS IN CONSTRUCTION ESTIMATION. ANY HELP WILL BE GREAT. THANKS -- DENNIS |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES IN EXCELL
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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES IN EXCELL
Thanks bob and Gord I will try that vba out and let you know if it works.
Thanks again for everyones help! -- Dennis "Bob Phillips" wrote: '----------------------------------------------------------------- Function DocProps(prop As String) '----------------------------------------------------------------- Application.Volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentĀ*Properties _ (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function and enter in a cell such as =DocProps ("creation date") -- HTH RP (remove nothere from the email address if mailing direct) "DENNIS" (NOSPAM) wrote in message ... IS THERE ANY WAY TO MAKE AN EXCELL WORKSHEET SHOW THE DATE IT WAS ORIGIONALLY CREATED AT THE TOP OF THE PAGE ? I KNOW HOW TO USE =TODAY AND =NOW FUNCTIONS BUT THESE RESET THE DATE AND TIME EACH TIME THE SHEET IS SAVED OR MODIFIED. I NEED TO SHOW THE DATE OF CREATION AS WELL AS THE LAST DATE OF MODIFICATION ON MY WORKSHEET. I USE EXCEL TO PREPARE MATERIAL LISTS IN CONSTRUCTION ESTIMATION. ANY HELP WILL BE GREAT. THANKS -- DENNIS |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES IN EXCELL
thanks to Don as well , you were very helpful
-- DENNIS "Bob Phillips" wrote: '----------------------------------------------------------------- Function DocProps(prop As String) '----------------------------------------------------------------- Application.Volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentĀ*Properties _ (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function and enter in a cell such as =DocProps ("creation date") -- HTH RP (remove nothere from the email address if mailing direct) "DENNIS" (NOSPAM) wrote in message ... IS THERE ANY WAY TO MAKE AN EXCELL WORKSHEET SHOW THE DATE IT WAS ORIGIONALLY CREATED AT THE TOP OF THE PAGE ? I KNOW HOW TO USE =TODAY AND =NOW FUNCTIONS BUT THESE RESET THE DATE AND TIME EACH TIME THE SHEET IS SAVED OR MODIFIED. I NEED TO SHOW THE DATE OF CREATION AS WELL AS THE LAST DATE OF MODIFICATION ON MY WORKSHEET. I USE EXCEL TO PREPARE MATERIAL LISTS IN CONSTRUCTION ESTIMATION. ANY HELP WILL BE GREAT. THANKS -- DENNIS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Can excell notify me of due dates? | New Users to Excel | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
lable ranges in Excell | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |