Closing ReadOnly file using VBA
 

I have following problem:

File is open as readonly. Some changes in this workbook are made. How
can I close this changed workbook using VBA if I wouldn´t save this
workbook as copy of original workbook?

Activeworkbook.close savechanges = false - didn´t work

Any idea?

Version: Excel 2000

Please help


---
Message posted from http://www.ExcelForum.com/

Closing ReadOnly file using VBA
 

Activeworkbook.close savechanges:= false

with the corrected syntax should work. It appear to work for most other
people.

--
Regards,
Tom Ogilvy


"acces " wrote in message
...
I have following problem:

File is open as readonly. Some changes in this workbook are made. How
can I close this changed workbook using VBA if I wouldn´t save this
workbook as copy of original workbook?

Activeworkbook.close savechanges = false - didn´t work

Any idea?

Version: Excel 2000

Please help


---
Message posted from http://www.ExcelForum.com/