hi,
I would like to know how to open an excel workbook in append mode(read/write mode) through code.
When i give

xlappdest.WorkBooks.Open(destfile)

wrote code to write some values into the sheet


xlappdest.ActiveWorkbook.Save
xlappdest.ActiveWorkbook.Close

But in the .Save line it's throwing up an error that the file (destfile) is opened only in
read mode and i can save only a copy of it.

How do i rectifiy this.

Thanks
sumanth

I open/write/close files all the time with VBA code, and the only time I can't save changes is when the file is marked read only within the file system, or someone has set the internal "Read Only Recommended" option. Do you have either of these situations? If the first, you need to turn off the read only option (which can be doen programmatically a couple of ways). If the second, I believe this option can be turned off programmatically, as long as the password is not also set.

Dave

hi dave,
how will you programmatically uncheck or disable the recommend Read only option in Excel.
thanks
sumanth

Workbooks.Open Filename:="Test.xls", IgnoreReadOnlyRecommended:=True


Dave

Dave can you help me out,
I am wanting to know how to write code to make a file read only...

Thanks Alot,

Jason