Hello,
I have an excell file with multiple worksheets in it. The code shown below does not creat the .txt file and also it does not convert all the workshees to csv(it only creates one work sheet always irrespective of the worksheet number I chage like 1, 2, 3, ....). Can any one help me? use Win32::OLE; $excel = Win32::OLE->new ('Excel.Application') || die "Could not open $! \n"; $sheet = $excel->workbooks->open("abcd.xls")->Worksheets(2); $sheet->SaveAs( "c:\\data1\\share\\abcd.csv",24); $sheet->SaveAs( "c:\\data1\\share\\abcd.txt",'xlText'); $excel-> Quit(); Thanks in advance Krishna _______________________________________________ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs