View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dukejas[_2_] dukejas[_2_] is offline
external usenet poster
 
Posts: 1
Default Do you know how to create a new sheet in a file by macro?


I need to export data to a file and seperate the data every day.

Do you know how to create a new sheet in a file by macro? How to apply
an existing macro to a new file without creat marcro and copy the code
every time? Because when I export data to a existing file, the macro
is lost.


Thanks a lot ! ---new bird


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/