Thread: dumb question
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default dumb question

Yes, but why not just do

Thisworkbook.Save

You don't need saveas unless you are changing the filename (which apparently
you are not).

--
Regards,
Tom Ogilvy

"ForSale " wrote in message
...
and this will force the answer of 'yes' when it asks to save over an
existing file?


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