Re: xls batch operation

de Chris 06/06/2006 08:57

"John Stubbings" <anna.riceDELETE-THIS@virgin.net> wrote in message
news:e63672$g8u$1@news.freedom2surf.net...
>
> I have about 100 xls files that I want to extract three columns from
> each and combine into one file.
>
> Any ideas?
>
>

The only way that I can think of is via VBA.
Put all the files in a single folder and loop through each one copying the
columns that you need.