Excel-VBA: BuiltInProperty "Last Save Time" doesn't work 
Author Message
 Excel-VBA: BuiltInProperty "Last Save Time" doesn't work

The Code:

  For Each p In ActiveWorkbook.BuiltinDocumentProperties
    Debug.Print "Name:" & p.Name
    On Error Resume Next
    Debug.Print "Value: " & p.Value
    On Error GoTo 0
  Next

results in a list of the document properties. Some of them work, but the one
I need
"Last Save Time" returns in a runtime error (in the code above there's no
line with "value: ")

The document IS saved and HAS a date of the last change in FILE / PROPERTIES

Any ideas?

Thanks in advance!
Bernhard



Mon, 19 Jan 2004 20:22:23 GMT  
 Excel-VBA: BuiltInProperty "Last Save Time" doesn't work
Excel (and all Office apps) have the same suite of BuiltInProperties
(did you see "Number of Slides"?). Excel, however, at least through
Xl200(0|1) doesn't maintain them.

Chip Pearson has a full discussion and workarounds at:

   http://cpearson.com/excel/docprop.htm



Quote:
> The Code:

>   For Each p In ActiveWorkbook.BuiltinDocumentProperties
>     Debug.Print "Name:" & p.Name
>     On Error Resume Next
>     Debug.Print "Value: " & p.Value
>     On Error GoTo 0
>   Next

> results in a list of the document properties. Some of them work, but the one
> I need
> "Last Save Time" returns in a runtime error (in the code above there's no
> line with "value: ")

> The document IS saved and HAS a date of the last change in FILE / PROPERTIES

> Any ideas?

> Thanks in advance!
> Bernhard

--

ROT13 encoding, decode for real mail


Mon, 19 Jan 2004 20:56:55 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. SendKeys "{tab}" doesn't work

2. 0 works, "" doesn't

3. GetObject("","InternetExplorer.Application") fails in Excel VBA

4. GetObject("","InternetExplorer.Application") fails in Excel VBA

5. Changing "last saved by" property

6. "Last saved by" property

7. "Replace"-Message doesn't prompt

8. "Replace"-Message doesn't prompt

9. autoscrollposition doesn't "stick"

10. Why CreateObject("MyDLLName.MyClsName","MTSServerName") doesn't work?

11. Excel save/overwrite "fails"

12. CreateObject("Excel","//server"), MsgBox output

 

 
Powered by phpBB® Forum Software