LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default workbook.saved property

Hi all

I wrote some VBA code which should detect if the workbook has just been
created through a template or already been saved (*.xls). When testing
for the Saved property I was a little bit confused finding the value
already set TRUE.

Private Sub Workbook_Open()
If ThisWorkbook.Saved = True Then
'jop - never been saved, empty path. saved is TRUE anyway???
GoTo WBSaved
End If
End Sub

Has anybody an explanation for this or is it a bug (solution,
workaround ?).
There exist postings about confusing behaviour of 'Workbook.Saved'
property value. But I didn't find a suitable solution for my problem,
yet.

Any ideas, suggestions? Thanks!

 
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
How can I see a copy of a saved workbook before I saved it again? Norma Excel Worksheet Functions 2 May 11th 05 10:31 AM
Catch _AfterSave Event & Saved Property Problem ... Joe HM Excel Programming 7 March 17th 05 11:30 AM
Changing Workbook Property PosseJohn Excel Programming 1 December 12th 04 08:25 PM
'Saved' Property not working Jim Rech Excel Programming 2 August 5th 04 11:39 PM
Access to class property in other workbook BenD[_2_] Excel Programming 2 March 3rd 04 09:11 AM


All times are GMT +1. The time now is 02:17 PM.

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

About Us

"It's about Microsoft Excel"