Excel Insert worksheet

[breemb]

I am having trouble trying to insert an excel worksheet from one workbook into another workbook. None of the excel functions seem to work for me and I am having a problem trying to find a good example. Basically what my program does is it will collect temperature data from an appliance over an hours time and then spit this data to an excel template which already has an implemented graph and a formula chart. The graph that I am using is an older excel graph which cannot be changed. After the data is added to the excel spreadsheet, the excel graph will update with the new data and I run a few macros to process the data and save to the formula chart. The issue though is, I don't know upfront how many tests I need to run so I want to add a spreadsheet template (which has the embedded graph and chart) to the end of the workbook and follow the same data process from above. This will happen for as many tests as I need to run. Can anyone help me with this issue.

[CptZizu]

I'm working on the attached vi, which in its current state will copy a sheet from an excel file to another bringing along the formatting, etc.  It copies fine, however I'm having trouble closing out Excel after the vi executes (which isn't a huge problem but I would like to solve it).  

Can anyone shed some light as to why that is happeining?

[ben64]

I can't open your VI since I'm using LV2009 but the way to close Excel is to use the _Application Quit method.

Ben64

[CptZizu]

Isn't that what this is?  Or am I using it in a wrong way?

[ben64]

We can't see from your picture what is referenced to the _Application quit method and also why you are using it twice. Is there an error reported?

Ben64

[CptZizu]

I've opened 2 excel references, the original where I'd like the second excel sheet to merge into, and the one with the sheet to be merged.  Attached should be the whole vi so you can get a better idea.

Edit:  I do not get an error reported

[CptZizu]

Would it work to open Excel once, and choose different workbooks within that (for the different files)?  This is my first project with activeX so I have a bit of a learning curve, and I do appreciate the help.

[ben64]

I think you should definitely use only one Excel._Application reference. A difference I noted is that in one of my vi I use the  _Workbook.Close method before closing the application.

Ben64 

[CptZizu]

Thanks for the help ben64.  I've revised it to use only one Excel._Application reference, and added the _Workbook.Close method, but Excel stays open as one of the processes (the application itself is hidden).  Still works like a charm, just doesn't want to close out of Excel.

[ben64]

Are you sure there is no error reported in the error cluster?

Ben64