I dont even get the 3 sheets that comes up. It only gives me 1. But I'll work with this file and see if I can give it the number of sheets I want.
Any ideas on how to keep the data in the file even after I close the excel file and reopen it back up?
Can you please give more details as to what is not working with this VI? When I run the VI, it creates the file I request, with the correct number of sheets that are named as specified in the VI. In fact, it even saves the VI in the location that I specify. I believe that this VI does accomplish what you are trying to do. If I have misunderstood your question in anyway though, please do not hesitate to clarify by reposting your issue on this forum.
Best of luck on your application, and have a great day!!