Adding a new sheet to a report using a template

[brandon20]

I have a template with 5 sheets if i fill all 5 sheets with data then i need to add 5 more sheets using the template.  I am stuck and dont know where to go from here.  I am using LV 8.5 with the report generation toolkit.  Please responed if you have any ideas of how i could do this

[GovBob]

These is a vi under report generation>>Excel specific>>Excel general>>Excel add worksheet.vi  Have you tried using that?

Hope this helps.

[brandon20]

yes i have tried using that but the problem is that it adds a new blank worksheet not the template version that i need it to be like.  What i am trying to mimic is when you go in to excel and click on one of the sheet tabs and click on move or copy then move and create a copy to the end.  This way i have the template form there with all the bookmarks setup.  Does anyone know how to do this

Message Edited by brandon20 on 06-05-2008 08:52 AM

[MikeS81]

Hi brandon20,

you can do it also in labview with the copy function. Use the ActiveX function to select the sheet you want to copy and connect this reference to the copy invoke node. See the attached picture.

Mike