thanks, but i ama ware of that. Im currently saving each sheet as a csv file
and then opening them as text file and appending the file information. Im
interested if there is a quicker way around it


"Mallycat" wrote:

>
> I think you can only have 1 sheet in a CSV file
>
>
> --
> Mallycat
> ------------------------------------------------------------------------
> Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
> View this thread: http://www.excelforum.com/showthread...hreadid=553139
>
>