View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Copy several range from all files in folder into several worksheets

Adri,


with the addition of 'dim fso as object' is runs fine for me too.

see my elaborate answer to your multipost in nl.office.excel


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Tom Ogilvy" wrote:

I recreated the environment you describe and ran the code. It ran
fine for me.