Reeza, I'm opening an existing workbook, writing out a new sheet, and then I want to save the workbook with a different name. Basically the workbook is a template, so I want to open the template, write out the new data and then save it so it reflects the data in there. This way I can run my code multiple times and end up with multiple workbooks populated instead of having to put a new template workbook in the folder each time. With proc export is it possible to specify a workbook to open and then specify a different one to save as?
... View more