add excel template

[klaus08]

Hello,

I'm able to add a new Worksheet to any EXCEL-file. Now I've created my own template of an worksheet. How can I choose which template should be add? The first template ist the MS standard-template and the second is my own template.

Thanks for help

[MikeS81]

Hi Klaus08,
i think one way is to open the template and the use of the copy function. Open your template and use the function copy. As "before" or "after" sheet, select a worksheet in your document where you want to copy the template to.

Hope it helps.
Mike

[T.Wakugawa]

Hello Kevin

Thank you for your reply and I'm sorry that my reply is late.

I suggested my customer to write a simple macro and use Run Macro VI as you mentioned in last post.
However, my customer has not wrote macro program and the template that my customer is using is pre complicated.
Then, I think the workaround wouldn't be good in this case.
I attached the template file just for your information.

Now, I'm thinking if I could copy a worksheet from the template workbook and past the worksheet to another workbook, that might be an acceptable workaround.
I found the DF below which is similar problem but I don't know how I could use the function copy.
" add excel template"
http://forums.ni.com/ni/board/message?board.id=170&message.id=327586&requireLogin=False

So, my question this time is below.
Is there a way to capy a excel worksheet and paste the excel worksheet by LabVIEW ?

Any information would be appreciate.
Thank you for your time.

Tomomitsu Wakugawa
AE @ NIJ

[T.Wakugawa]

Sorry I forgot to attach the template file.

The file created by Excel 2003.

Thank you. 

Tomomitsu Wakugawa

AE @ NIJ

[klaus08]

Hello T.Wakugawa, I think the vi below could be the solution to your problem. the vi is created by LV8.6

[T.Wakugawa]

Hello klaus08

Thank you for your response. The VI you attached works great !
That is what I wanted.

I really appreciate that.
Thank you again.

Tomomitsu Wakugawa