If you do your saveAs first, the active workbook gets that new name. And you
can delete the old file without changing the readonly stuff.

dim OldName as string
dim newfilename as string
....
with thisworkbook
oldname = .fullname
'make sure newfilename isn't the same as oldname!
.saveas filename:=newfilename, FileFormat:=xlNormal
kill oldname
end with

(I didn't test this--so watch out!!)



Slow1911s wrote:

Well - it is. See post #1

Is there another method I can use other than saveas?

--
Slow1911s
------------------------------------------------------------------------
Slow1911s's Profile: http://www.excelforum.com/member.php...o&userid=31113
View this thread: http://www.excelforum.com/showthread...hreadid=511158

--

Dave Peterson