the123punch Posted February 16, 2010 Share Posted February 16, 2010 Hi all, I am using the Excel UDF to write a report to an Excel document. My report consists of several sheets (~15 sheets). I am able to generate the report programatically without any problem, and save the entire workbook as well. However, I want to be able to save each worksheet separately. Is that possible with the UDF? I tried to manipulate code from the Excel UDF but I couldn't get with any result and kept getting errors. Ideally, I would like to loop through the Workbook object and save each worksheet individually as an Excel Workbook document. Each file would be named according to the worksheet name. Thanks. the123punch Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now