Thread: Copy sheets to mulitple workbooks in a directory
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Copy sheets to mulitple workbooks in a directory
Start here
http://www.rondebruin.nl/copy4.htm

See the example
"Copy a worksheet to all workbooks in a folder"
You can change that to copy more then one sheet


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Greg" wrote in message ...
Hi. I need a hand with some code to copy/export 3 sheets into
multiple workbooks in a directory. These are newly formatted sheets
that are needed to be added to the existing workbooks.

All these workbooks are identically formatted and I would like to
insert the new sheets after sheet named "PVM". Thanks in advance.
Reply With QuoteReply With Quote