Thread: Copying and pasting a worksheet to a different excel workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil Holden Neil Holden is offline
external usenet poster
  
Posts: 163
Default Copying and pasting a worksheet to a different excel workbook
HI all,

I have an excel workbook which contains around 60 worksheets.

I need to have a bat file or a vb script to automatically copy one
particular worksheet into another excel document. The other excel document
will always be stored in one place but i want it to automatically update on a
daily basis.

Any thoughts would be much appreciated.
Reply With QuoteReply With Quote