Save ReadOnly file

  • Thread starter Thread starter acces
  • Start date Start date
A

acces

I have following problem:

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

Activeworkbook.close savechanges = false - didn´t work

Any idea?

Version: Excel 2000

Please hel
 
Is this a typo in the post or in your code:

Activeworkbook.close savechanges = false
Should look like this (notice the colon)

Activeworkbook.close savechanges:=false

If it was a typo in the post, what kind of error do you get. (I've used this
and it worked ok for me.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top