Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Problem with Document Properties

the BuiltInDocumentProperties("Creation Date") is returning the original date:

i.e. if you write a doc and saveAs 2 months later and save as another 2
months later it is returning the original date from four months ago...however
the file/document properties says it was created on the latest date...

I need the latest date....any ideas...
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Problem with Document Properties

Okay...I'm seeing that i need Dos or the windows properties...can/how do you
retrieve those...

"jasminesy" wrote:

the BuiltInDocumentProperties("Creation Date") is returning the original date:

i.e. if you write a doc and saveAs 2 months later and save as another 2
months later it is returning the original date from four months ago...however
the file/document properties says it was created on the latest date...

I need the latest date....any ideas...

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Problem with Document Properties

This is from VBA Help. It might be what you are looking for.

Sub ShowFileAccessInfo(filespec)
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
s = UCase(filespec) & vbCrLf
s = s & "Created: " & f.DateCreated & vbCrLf
s = s & "Last Accessed: " & f.DateLastAccessed & vbCrLf
s = s & "Last Modified: " & f.DateLastModified
MsgBox s, 0, "File Access Info"
End Sub



"jasminesy" wrote:

Okay...I'm seeing that i need Dos or the windows properties...can/how do you
retrieve those...

"jasminesy" wrote:

the BuiltInDocumentProperties("Creation Date") is returning the original date:

i.e. if you write a doc and saveAs 2 months later and save as another 2
months later it is returning the original date from four months ago...however
the file/document properties says it was created on the latest date...

I need the latest date....any ideas...

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Document Properties Bauhinia Excel Discussion (Misc queries) 1 October 23rd 07 12:33 PM
Properties of a document, help! Jason Excel Worksheet Functions 2 February 24th 06 10:47 AM
Document Properties Barb R. Excel Worksheet Functions 5 May 23rd 05 04:55 PM
Document properties Rob Bovey Excel Programming 0 July 20th 04 07:09 PM
Document properties Tom Ogilvy Excel Programming 0 July 20th 04 06:58 PM


All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"