Last Save Time?!?

[tom]

Hello

I have a question about the property "Last save time" of the object
BuiltinDocumentProperties. Why doesn't this function supply a result
although the file was stored? I can also use the function FileDateTime, but
this function changes every time, when the file will be opened. Is there
another (better) possibility of accessing the property "Last save time"?

Tom

[Tom Ogilvy]

The buildindocumentproperties are supported across all the Office
applications, but each application does not maintain every property. The
Last save time is not supported in Excel 97 - I don't recall whether it is
maintained in later versions. You can write code that will run and update it
if you want - but Excel doesn't do it for you (at least in Excel 97).

Regards,
Tom Ogilvy

tom <tstr...@swissonline.ch> wrote in message
news:eIWVtv9zAHA.892@tkmsftngp05...

[Leo Heuser]

MsgBox ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")

works OK for me (Excel 97 SR-2 and Excel 2000 SR-1)????

Best regards
LeoH

"Tom Ogilvy" <twog...@email.msn.com> skrev i en meddelelse
news:u4LfoZ#zAHA.1788@tkmsftngp02...

[tom]

Thanks for your answer. This function seems to work with Excel 2000. But
with Excel 97 SR-1 (german) an error occurs...

Tom

"Leo Heuser" <leo.h...@get2net.dk> wrote in message
news:ect2#qA0AHA.1436@tkmsftngp03...

[Tom Ogilvy]

Leo - it appears experiences may be different. See some postings I have
included below my response.
Hope this answers your "?????"

I had a different experience: (and my file has been saved previously).

Sub Tester3()
Dim obj As DocumentProperty
On Error Resume Next
i = 0
For Each obj In Workbooks("Test1.xls").BuiltinDocumentProperties
i = i + 1
Debug.Print i, obj.Name, obj.Value
Next
End Sub

Produced:
1 Title
2 Subject
3 Author Thomas Ogilvy
4 Keywords
5 Comments
6 Template
7 Last author Thomas Ogilvy
8 Revision number
9 Application name Microsoft Excel
11 Creation date 4/26/01 10:18:04 PM
17 Security 0
18 Category
19 Format
20 Manager
21 Company Personal Copy
29 Hyperlink base

======<Chip Pearson posted this back in 1999, so he was probably using xl97
at that time:

From: Chip Pearson (cpea...@gvi.net)
Subject: Re: Date/Time file last updated
Newsgroups: microsoft.public.excel.misc,
microsoft.public.excel.worksheet.functions
Date: 1999/03/20

You can also use the "Last Save Time" built-in document property. For
whatever reason, Excel doesn't maintain this property on its own, so
you have to do it manually.

Private Sub App_WorkbookBeforeSave(ByVal Wb As Excel.Workbook, ByVal
SaveAsUI As Boolean, Cancel As Boolean)
Wb.BuiltinDocumentProperties("Last Save Time").Value = Now
End Sub

Cordially,
Chip Pearson
http://home.gvi.net/~cpearson/excel

=======Myrna Larson confirms in an even older post:

>Myrna Larson wrote in message <360b2b89...@msnews.microsoft.com>...
>>On Tue, 22 Sep 1998 22:17:58 -0500, "Chip Pearson" <cpea...@gvi.net>
>>wrote:
>>
>>>How do you get a value of 0 from
>>>Msgbox b.BuiltInDocumentProperties("Last save time")
>>>
>>>I get an Automation Error (-2147467259) when I try this (Excel97 SR1
8.0d).
>>
>>I got the same error. I think I finally did this:
>>
>> Dim d As Date
>> On Error Resume Next
>> d = b.BuiltInDocumentProperties("Last save time")
>> Msgbox Format$(d, "mm/dd/yyyy hh:mm AM/PM")
>>
>>So I should have said that Excel doesn't support that property, not that
it
>>always returns 0. It must be used only by Word.
>>
>>In the above code, d was 0 because it was never set, not because the
>>function returned a 0.
>>
>

========< Now using Excel 2000, Myrna is getting a value:

From: Myrna Larson (myrna...@home.net)
Subject: Re: Last Saved
Newsgroups: microsoft.public.excel.programming
View complete thread (2 articles)
Date: 2000/02/16

I'm a bit confused since you posted a question in the Excel programming
group, but you refer to a Word document.

If you are talking about a closed file, check out the FileDateTime function.

If you mean an open Excel workbook, and you are using XL2000, you can check
BuiltinDocumentProperties

Dt = Workbooks("MyFile.xls").BuiltinDocumentProperties("last save time")

If you are using an earlier version, there are problems: Excel doesn't
maintain this property.

When Excel opens a file, it changes the date/time to the time when it is
opened.

Jim Rech has found that if you change the file status to Read Only, the time
will be set back. The code looks something like this:

Dim Dt As Date
Dim FileName As String

Application.DisplayAlerts = False
FileName = "Myfile.xls"
Workbooks(FileName).ChangeFileAccess xlReadOnly
Dt = FileDateTime(FileName)
Workbooks(FileName).ChangeFileAccess xlReadWrite
Application.DisplayAlerts = True

MsgBox FileName & ", " & Dt

But in fiddling with this just now, I found that if the file has been
changed between the time it is opened and the time the above code executes,
and Alerts are not displayed, Excel saves the file before changing the
access mode. That, of course, defeats the purpose of the whole thing.

Here are some other options:

You could get the date before you open the file, from a macro in another
workbook.

You could set up a Workbook_BeforeSave event macro that saves the date and
time in a worksheet cell.

You can implement an application class module with a routine that updates
the "Last Save Time" whenever any workbook is saved. Chip Pearson's web page
(www.cpearson.com, I think it is) has information on class modules.

====== Here is a thread from a previous similar posting: - this indicates
experiences may differ - installing Excel 2000 may make a difference.

From: Daryl J. Lucas (dlu...@ibbotson.com)
Subject: BuiltinDocumentProperties("Last Save Time") error
Newsgroups: microsoft.public.excel.programming
Date: 1999/08/11

Hello all,

I am trying to retrieve the "Last Save Time" BuiltinDocumentProperty of an
Excel 97 workbook. The following code, however, raises an error:

Dim o As Excel.Workbook
Set o = ActiveWorkbook
MsgBox o.BuiltinDocumentProperties("Last Save Time")

I get run-time error -2147467259, "Automation error" and "Unspecified
error". Adding .Value to the end of the call changes the error message but
not the number: "Method 'Value' of object 'DocumentProperty' failed".

A knowledge base article says that you should expect this with a workbook
that has not been saved to disk, but I get the error with all workbooks
whether they've been saved or not. Does anyone know why or how to work
around this? I am running Excel 97 SR-2.

Many thanks.

--
-Daryl J. Lucas

Message 2 in thread
From: Jennifer A. Campion (jenn...@neta.com)
Subject: Re: BuiltinDocumentProperties("Last Save Time") error
Newsgroups: microsoft.public.excel.programming
Date: 1999/08/11

Not that this will help you any, but it works for me with Excel 2000.

Jennifer A. Campion

Daryl J. Lucas <dlu...@ibbotson.com> wrote in message
news:01bee40c$1c76c9c0$18aa68c0@daryl...
> Hello all,
>
> I am trying to retrieve the "Last Save Time" BuiltinDocumentProperty of an
> Excel 97 workbook. The following code, however, raises an error:
>
> Dim o As Excel.Workbook
> Set o = ActiveWorkbook
> MsgBox o.BuiltinDocumentProperties("Last Save Time")
>
> I get run-time error -2147467259, "Automation error" and "Unspecified
> error". Adding .Value to the end of the call changes the error message but
> not the number: "Method 'Value' of object 'DocumentProperty' failed".
>
> A knowledge base article says that you should expect this with a workbook
> that has not been saved to disk, but I get the error with all workbooks
> whether they've been saved or not. Does anyone know why or how to work
> around this? I am running Excel 97 SR-2.
>
> Many thanks.
>
> --
> -Daryl J. Lucas

Message 3 in thread
From: Duncan Chege (Duncan...@ncmail.net)
Subject: Re: BuiltinDocumentProperties("Last Save Time") error
Newsgroups: microsoft.public.excel.programming
Date: 1999/08/11

Try this,

MsgBox ActiveWorkbook.BuiltinDocumentProperties(10)

There is no high better than helping someone in VBA Excel.
Duncan

"Daryl J. Lucas" wrote:

> Hello all,
>
> I am trying to retrieve the "Last Save Time" BuiltinDocumentProperty of an
> Excel 97 workbook. The following code, however, raises an error:
>
> Dim o As Excel.Workbook
> Set o = ActiveWorkbook
> MsgBox o.BuiltinDocumentProperties("Last Save Time")
>
> I get run-time error -2147467259, "Automation error" and "Unspecified
> error". Adding .Value to the end of the call changes the error message but
> not the number: "Method 'Value' of object 'DocumentProperty' failed".
>
> A knowledge base article says that you should expect this with a workbook
> that has not been saved to disk, but I get the error with all workbooks
> whether they've been saved or not. Does anyone know why or how to work
> around this? I am running Excel 97 SR-2.
>
> Many thanks.
>
> --
> -Daryl J. Lucas

Message 4 in thread
From: Daryl J. Lucas (dlu...@ibbotson.com)
Subject: Re: BuiltinDocumentProperties("Last Save Time") error
Newsgroups: microsoft.public.excel.programming
Date: 1999/08/11

Duncan,

> Try this,
>
> MsgBox ActiveWorkbook.BuiltinDocumentProperties(10)

No go. Same errors.

--
-Daryl J. Lucas

Message 5 in thread
From: Jim Rech (jar...@kpmg.com)
Subject: Re: BuiltinDocumentProperties("Last Save Time") error
Newsgroups: microsoft.public.excel.programming
Date: 1999/08/11

I get the error too. But only if the workbook has not been saved.

--
Jim Rech
Excel MVP

Message 6 in thread
From: Daryl J. Lucas (dlu...@ibbotson.com)
Subject: Re: BuiltinDocumentProperties("Last Save Time") error
Newsgroups: microsoft.public.excel.programming
Date: 1999/08/11

I get it with all workbooks, saved or not, local or network.

--
-Daryl J. Lucas

Jim Rech <jar...@kpmg.com> wrote in article
<#mQ7pIB5#GA....@cppssbbsa02.microsoft.com>...
> I get the error too. But only if the workbook has not been saved.
>
> --
> Jim Rech
> Excel MVP
>
>
>
>

Message 7 in thread
From: Jim Janssen (jjan...@kpmg.com)
Subject: Re: BuiltinDocumentProperties("Last Save Time") error
Newsgroups: microsoft.public.excel.programming
Date: 1999/08/11

I have the exact same problem with the exact same error message. "Last Save
Time" just does not work. I tried "Creation Date", and it worked just fine.

I am using Excel 97 SR-2 with the additional patches to get to version (h).

--Jim

Daryl J. Lucas <dlu...@ibbotson.com> wrote in message
news:01bee413$e72b9fe0$18aa68c0@daryl...
> I get it with all workbooks, saved or not, local or network.
>
> --
> -Daryl J. Lucas
>
> Jim Rech <jar...@kpmg.com> wrote in article
> <#mQ7pIB5#GA....@cppssbbsa02.microsoft.com>...
> > I get the error too. But only if the workbook has not been saved.
> >
> > --
> > Jim Rech
> > Excel MVP
> >
> >
> >
> >

Message 8 in thread
From: Bob Umlas (rum...@kpmg.com)
Subject: Re: BuiltinDocumentProperties("Last Save Time") error
Newsgroups: microsoft.public.excel.programming
Date: 1999/08/11

Odd: This exact code
Sub aaa()
Dim o As Excel.Workbook
Set o = ActiveWorkbook
MsgBox o.BuiltinDocumentProperties("Last Save Time")
End Sub
works fine for me in Excel97 & 2000 (a saved file).
Obviously, something's different between all our versions/settings!
Bob Umlas
Excel MVP
rum...@kpmg.com

Jim Janssen <jjan...@kpmg.com> wrote in message
news:OSHtcqB5#GA.206@cppssbbsa04...
> I have the exact same problem with the exact same error message. "Last
Save
> Time" just does not work. I tried "Creation Date", and it worked just
fine.
>
> I am using Excel 97 SR-2 with the additional patches to get to version
(h).
>
> --Jim
>
>
> Daryl J. Lucas <dlu...@ibbotson.com> wrote in message
> news:01bee413$e72b9fe0$18aa68c0@daryl...
> > I get it with all workbooks, saved or not, local or network.
> >
> > --
> > -Daryl J. Lucas
> >
> > Jim Rech <jar...@kpmg.com> wrote in article
> > <#mQ7pIB5#GA....@cppssbbsa02.microsoft.com>...
> > > I get the error too. But only if the workbook has not been saved.
> > >
> > > --
> > > Jim Rech
> > > Excel MVP
> > >
> > >
> > >
> > >
>
>

Leo Heuser <leo.h...@get2net.dk> wrote in message
news:ect2#qA0AHA.1436@tkmsftngp03...

> MsgBox ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
>
> works OK for me (Excel 97 SR-2 and Excel 2000 SR-1)????
>
> Best regards
> LeoH
>
>

==========<END>========

--
Regards,
Tom Ogilvy

[Leo Heuser]

Thanks for the overview Tom.
Apparently only Bob Umlas and I can get a result, so
I guess my "?????" have turned into "?????????" :-)

Best regards
LeoH

"Tom Ogilvy" <twog...@email.msn.com> skrev i en meddelelse

news:#MnuyQB0AHA.1400@tkmsftngp05...

>
>
> Leo - it appears experiences may be different. See some postings I have
> included below my response.
> Hope this answers your "?????"
>

> Regards,
> Tom Ogilvy
>
>
>

[Chip Pearson]

Possible explanation: Do you have anything in an add-in or
personal.xls that gets the BeforeSave event and puts a value in
the property? I thought is worked for me in 97 until I remembered
my personal.xls automatically updates that property.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"Leo Heuser" <leo.h...@get2net.dk> wrote in message

news:ujt4XfB0AHA.960@tkmsftngp03...

[Tom Ogilvy]

Leo,
Try creating a new file in Excel 97. Save the file, close and open it a
couple of times, saving it some times - but always only in Excel 97. Then
open it in Excel 97 and see if you can access the property. I bet that the
files you tested have been opened in Excel 2000 and it (Excel 2000) writes
the "last save time". As Chip said, once a value is assigned, the property
is accessible in either version - without any help, Excel 97 doesn't seem to
maintain/write the property. Just a thought.

Regards,
Tom Ogilvy

Leo Heuser <leo.h...@get2net.dk> wrote in message

news:ujt4XfB0AHA.960@tkmsftngp03...

[Dana DeLouis]

If anyone is interested, I modified the neat code from Tom and Chip.
This lists all 30 "BuiltinDocumentProperties" (Excel 2000) and any
"CustomDocumentProperties".
Those items that cause errors when accessing the value property are listed
as < >
Like other have mentioned, you can go back and modify those properties on
your own that cause errors.

Sub DocumentProperties()
Dim obj As DocumentProperty
Dim i As Long

Debug.Print
Debug.Print "BuiltinDocumentProperties for..."
Debug.Print "Book: " & ActiveWorkbook.FullName

On Error Resume Next
With ActiveWorkbook.BuiltinDocumentProperties
For i = 1 To .Count
Debug.Print i, .Item(i).Name & ": ", .Item(i).Value
If Err.number <> 0 Then
Debug.Print i, .Item(i).Name & ": ", "< >"
Err.Clear
End If
Next
End With

Debug.Print "- - - - - - - - - -"
Debug.Print "CustomDocumentProperties..."

With ActiveWorkbook.CustomDocumentProperties
For i = 1 To .Count
Debug.Print i, .Item(i).Name & ": ", .Item(i).Value
Next
If .Count = 0 Then Debug.Print " No CustomDocumentProperties"
End With

Debug.Print "- - - - - - - - - -"
End Sub

Partial results...
..etc

9 Application name: Microsoft Excel

10 Last print date: < >
11 Creation date: 10/28/1998 2:16:23 AM
12 Last save time: 4/28/2001 6:39:02 PM
13 Total editing time: < >
..etc
30 Number of characters (with spaces): < >
- - - - - - - - - -
CustomDocumentProperties...
1 SaveThisFileQ: False
- - - - - - - - - -

However, I too have a question. When I create a New workbook, the Creation
date is always "10/28/1998"
I have done an advanced file search on my hard drive for any files with this
date / time stamp.
I have found nothing. I was expecting a template or something. However,
this does not appear to be the case.
In Excel, if I go to <File><Properties> and click the General tab, I see a
creation date of today, which would be correct for clicking File.New, or
hitting the New Workbook button.
When anyone else creates a new workbook, do you get a current "Creation
date" from the above macro?
It does not matter if I save the file or not. I would be curious if this
happens to anyone else.??

Just to add for programming ideas along the idea of the "BeforeSave" event
that Chip mentioned.
Suppose you use Excel to import data, and have a macro clean up that data
and put it into some meaningful way to examine.
If you only run this macro to look at the data, and have no intention of
saving the newly created file, you could create a Custom document property
who's only purpose is to tell the BeforeSave event that the file should not
be saved.
I use this often. After a macro does a File Import, I run a quick macro to
set a custom document property.
Later when I close this file, the file just closes without a "Do you want to
save changes..." prompt.

<snip>

[Chip Pearson]

> However, I too have a question. When I create a New workbook,
the Creation
> date is always "10/28/1998"
> I have done an advanced file search on my hard drive for any
files with this
> date / time stamp.

I suspect that the date is coming from your XLStart\Book.xlt
template file. If the workbook is created based on that, it is
simply a copy of that file, so you'll get that create date. The
create date listed in File>Properties comes from the File System
(file label) not the DocumentPropery value. In this case, you can
read the property before the newly created file is ever saved.

If you don't have a Book.xlt file, the create date isn't saved
until the file is written to disk, and attempting to read the
DocumentPropery value will raise an error. Once saved though, the
CreateDate DocumentPropery value is correct.

> Just to add for programming ideas along the idea of the
"BeforeSave" event
> that Chip mentioned.

Another somewhat useful feature is that you can search for files
from the File>Open dialog that have specific values in document
properties.

Also, you can read document properties of closed files with the
DSO library downloadable from MS. And since you can link
properties to cell values, you can make a cell value available to
file search without having to open the file. You can download
the DSOFile.exe from Q224351 at
http://support.microsoft.com/support/kb/articles/Q224/3/51.ASP

Dim DSO As DSOleFile.PropertyReader
Set DSO = DSOleFile.PropertyReader
Debug.Print DSO.GetDocumentProperties("C:\book1.xls").DateCreated

I have example code on my web site for reading and writing
built-in and custom document properties.
http://www.cpearson.com/excel/docprop.htm

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"Dana DeLouis" <da...@email.msn.com> wrote in message
news:u#cNDlD0AHA.1932@tkmsftngp05...

[Tom Ogilvy]

I took the oldest file I could find and named it Book.xlt and put it in the
xlstart directory. When I did file=>New and ran you code, I got

11 Creation date: 4/6/99 8:49:11 PM

Which corresponds to the created date in the statistic tab of File =>
Properties of the original file (but the the created date on the General Tab
of File=>Properties)

When I look at the Statistics Tab of File =>Properties in the new workbook
(which hasn't been saved), the Created Date and Printed Date match the
Template file.

Do you have a book.xlt file?

Regards,
Tom Ogilvy

Dana DeLouis <da...@email.msn.com> wrote in message
news:u#cNDlD0AHA.1932@tkmsftngp05...

[Dana DeLouis]

Thank you TomOgilvy & Chip Pearson. You were correct in that the date was
coming from Book.xlt.
This was the first place I looked, but I missed it.
Apparently, when you Right Click a file in Explorer, and choose Properties,
the Created date on the "General" Tab is different than the Created date on
the "Statistics" tab.
I was also searching for files using Windows "find files" and was doing a
search for files "Created" on that specific date. I had no luck.
It appears that Windows does a File search for Created Date based on the
date on the General Tab of the File's properties.
The Creation date for Built in Documents appears to use the Creation Date
based on the "Statistics" Tab.
Whew...did I say that right?
If I delete (or just rename) Book.xlt, creating a new workbook is based on
the built in settings of Excel, and the "Creation Date" of the built in
Documents is the current time.

I am sure there are no hidden issues, but I feel uneasy using Excel 2000 and
having "New" workbooks with a "Creation date" of 1998.
Therefore, I took the time and created a new Book.xlt based on using Excel
2000. Probably no difference, but I feel a little better.
Just to share an idea if anyone else is thinking of this also and has a few
custom Styles in their "Old" Book.xlt.
Rename your old Book.xlt, and then open it. Open a new workbook that will
be used for the new Book.xlt.
Under <Format><Styles>, select "Merge". This will merge the styles you have
defined in your old book.xlt into your new book.

Thank you Chip for the link on the DSO File. That is a nice addition.
I have a question on Early / Late binding that the article talks about.
However, I would like to start a new thread on that question.

The following is just an observation that I think is rather strange.
The macro's discussed above show such items as "Total editing time" as not
directly supported by Excel.
However, on the <File><Properties> "Statistics" Tab, there is a listing
for "Total editing time".
One would think that if Excel did not support this, then it would not be
listed on the Statistics Tab.
Just thought it strange, that's all.

Anyway, thanks again for your help. Dana.

"Chip Pearson" <ch...@cpearson.com> wrote in message
news:eabuS$D0AHA.1832@tkmsftngp05...
>
>
<snip>

>
> Also, you can read document properties of closed files with the
> DSO library downloadable from MS. And since you can link
> properties to cell values, you can make a cell value available to
> file search without having to open the file. You can download
> the DSOFile.exe from Q224351 at
> http://support.microsoft.com/support/kb/articles/Q224/3/51.ASP
>
> Dim DSO As DSOleFile.PropertyReader
> Set DSO = DSOleFile.PropertyReader
> Debug.Print DSO.GetDocumentProperties("C:\book1.xls").DateCreated
>
>
> I have example code on my web site for reading and writing
> built-in and custom document properties.
> http://www.cpearson.com/excel/docprop.htm
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com ch...@cpearson.com
>

<snip>

[Dana DeLouis]

Just to add if one finds it interesting.
It looks like you can change Document Properties with VBA even if the
Workbook is protected.
I could not tell if the article was trying to say if this is a "Feature" or
a "Bug." :>)

XL2000: Changing Protected Document's Properties with Visual Basic Macro
http://support.microsoft.com/support/kb/articles/Q213/3/94.ASP

[Chip Pearson]

> Thank you TomOgilvy & Chip Pearson. You were correct in that
the date was
> coming from Book.xlt.

You're most welcome. Sometimes we do get things right, even if
it does at times "Surprise" you! <g>

> I have a question on Early / Late binding that the article
talks about.
> However, I would like to start a new thread on that question.

Please do start a new thread, but I don't think that their are
any early/late binding issues specific to DSOle object beyond
your standard ActiveX issues. But please fire up a discussion.
It gets dull around here sometimes.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"Dana DeLouis" <da...@email.msn.com> wrote in message

news:OTY1ltF0AHA.572@tkmsftngp05...

[Chip Pearson]

Hi Dana,

I saw that article before, and found it curious. Interestingly,
the KB article states neither that "this is a known problem" nor
that "this is by design". Most KB articles stake out a position
one way or another. This one just acknowledges existence. I
guess Marketing is on Spring Break, and hasn't made a ruling yet.

To their credit, though, the "HasMacros" property is read-only.
You can't change that one !!!

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"Dana DeLouis" <da...@email.msn.com> wrote in message

news:ef5qvwF0AHA.1844@tkmsftngp05...

[Chip Pearson]

"Chip Pearson" <ch...@cpearson.com> wrote in message

> Dim DSO As DSOleFile.PropertyReader
> Set DSO = DSOleFile.PropertyReader

That should really be, of course:

Dim DSO As DSOleFile.PropertyReader
Set DSO = New DSOleFile.PropertyReader

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"Chip Pearson" <ch...@cpearson.com> wrote in message
news:eabuS$D0AHA.1832@tkmsftngp05...
>
>

[Leo Heuser]

Thanks Chip!
My problem was, as Tom suggested, that my test files
were saved in Excel 2000.

Best regards
LeoH

"Chip Pearson" <ch...@cpearson.com> skrev i en meddelelse
news:uGLqEpB0AHA.1256@tkmsftngp02...

[Leo Heuser]

And a good thought that was Tom! Thanks!
The tested workbooks *were* saved in Excel 2000.
When I created a new one in Excel 97, saved it etc.,
I'm happy to announce, that my version of Excel 97
also displays the automation error dialog box :-)

Best regards
LeoH

"Tom Ogilvy" <twog...@email.msn.com> skrev i en meddelelse

news:#SFbCrC0AHA.1264@tkmsftngp03...

[Drew Paterson]

Correct - MsgBox ActiveWorkbook.BuiltinDocumentProperties("Last Save Time") produces an "Automation Error" on my Excel97 SR2.

Drew

"Tom Ogilvy" <twog...@email.msn.com> wrote in message news:#MnuyQB0AHA.1400@tkmsftngp05...