is there anyway to create multiple sheet excel file with bunch of charts in these sheets through SAS . This report will be generated monthly and emailed to the users. The issue I am facing is
1. With excelXp tagset I can create multiple sheets but I can't create Charts
2.With MSoffice2k I Can create charts but not multiple sheets directly. Through hardway I know can create multiple html files and then combine them later. But Since the report I am working on has no luxury of opening the files manualy and saving( Reports get generated automattcally in unix and emailed), Is there any other way to do this .