Hi Cynthia, Thanks for the help. I want to tell you something that , My SAS 9.2 is running on Unix server and my MS addins and EG 4.2 is running on windows. I try to create my reports in xlsx format. In tagsets.ExcelXP using 9.2 you can create it but when I try to open the report itas give me and error and empty spreadsheet comes. Is that any way I tried all things, like convert the report after its created in xls and run the VBA script to convert in xlsx format. Is that and codes or way you can create it. All help should be appereciated, Thanks you, Shailesh Patel ... View more

I have to run the Stored process thrue SAS-Excel addins. to get the report. Can you help? ... View more

I'm using SAS 9.2. Can you send me any code. I tried it, created in xlsx, but when tried to open its won't open. Can you please help? Thanks ... View more

Hi, Thank you, I'm trying to create both ways, as my managers ask me to do it. The are doing the cover sheet and specification sheet manually. now they try to automate it so one person feed the data and report will comeout in wookbook format, with cover sheet and specificationpage included. You understand what I mean. can you help me in this one. One of your code, which help me to create the coversheet. But the cover sheet is so fancy and they have different customer they create different report and create new coversheet, thats the problem. I create template with coversheet and specification for each customer. Once If they want for this cust1 the report 1 will print with template1, cust2 the report2 will printed on template2 and so on..... I'm Using SAS.... can you help me...Please you understand what I mean. Shailesh Patel ... View more

Hi Cynthia, Thanks for the code....I want to know any way you can create excel workbook(create tabs). the excel Template(cover letter and specification) is already there, just to insert the data in seperate tabs. Is that any way we can do it in SAS code. If you have any example or code, can you please share the logic, I will greatly appericiated. Thank you, ... View more