View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
serge T serge T is offline
external usenet poster
 
Posts: 8
Default renaming a workbook

Hi all,

Out of one complex and large sized workbook, I export one sheet as new
workbook, rename it, clear all buttons and shapes and send it by mail. My
problem is that I have to save this new book to give it a relevant name
different of "book1" but I don't want to keep these temporary exchange files
and I don't know how to delete them automatically therafter...unless I don't
use the right export approach
Thanks to tell how you would try it.
Kind regards,
--
Serge