View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default Copy worksheets to control file

Check out Ron de Bruin's site.

http://www.rondebruin.nl/tips.htm

Browse through the codes you find under his Copy/Paste/Merge Examples.


Gord Dibben MS Excel MVP

On Mon, 20 Jun 2011 19:58:12 +0100, "Jim Lavery"
wrote:

Does anyone know what code I could use to copy sheets from several files in
the same folder into a master control file?