S
Simon Murphy
On a corporate network they have xl 2000 sp1 on win 2000
A user keeps getting corrupt workbooks, he has narrowed it
down to whenever he saves a file with more than 1 sheet
selected.
The workbooks open and save fine in XP and 2003 but will
not open in 2000, they always crash it (even after
reparing in 2003)
The only solution I have come up with is opening the file
in 2003 and rebuilding all the sheets and code into a new
workbook.
Looking in the vba ide there always seems to be a spare
Excel object, with no sheet associated, that has similar
properties to the 'thisWorkbook' object.
Has anyone else had the same problem and are there any
better fixes?
cheers
Simon
A user keeps getting corrupt workbooks, he has narrowed it
down to whenever he saves a file with more than 1 sheet
selected.
The workbooks open and save fine in XP and 2003 but will
not open in 2000, they always crash it (even after
reparing in 2003)
The only solution I have come up with is opening the file
in 2003 and rebuilding all the sheets and code into a new
workbook.
Looking in the vba ide there always seems to be a spare
Excel object, with no sheet associated, that has similar
properties to the 'thisWorkbook' object.
Has anyone else had the same problem and are there any
better fixes?
cheers
Simon