Clearing clipboard in Excel 2007

[MrSafe]

Hi,

I am using labview to copy large sets of data from one excel workbook to another this action gets repeated for new sets of data. The VI works fine there are no issues with the VI. 

However, when the VI runs more than once Excel prompts me asking me if I want to clear or save the previously copied data. I don't want to keep the data as a result I must always be present to click "no".  Is there a way for labview to clear the clipboard? I have tried searching the closest thing I found was a VBA code "Application.cutcopymode = False" but I can not replicate this in labview.

Does anyone know of a good clean method of clearing excels clipboard?

[smercurio_fc]

---

MrSafe wrote: I have tried searching the closest thing I found was a VBA code "Application.cutcopymode = False" but I can not replicate this in labview

---

Are you saying this because when you right-click on that property you get an enum that has values of xlCopy and xlCut only? You should be able to simply wire a zero to that input to be the equivalent of "False".

Alternatively, from what I've read, if you use wire a range to the "Destination" input parameter for the "Copy" method then that bypasses the clipboard alltogether.

[MrSafe]

---

smercurio_fc wrote:

---

MrSafe wrote: I have tried searching the closest thing I found was a VBA code "Application.cutcopymode = False" but I can not replicate this in labview

---

Are you saying this because when you right-click on that property you get an enum that has values of xlCopy and xlCut only? You should be able to simply wire a zero to that input to be the equivalent of "False".

Alternatively, from what I've read, if you use wire a range to the "Destination" input parameter for the "Copy" method then that bypasses the clipboard alltogether.

---

I have tried the underlined and bolded method. It doesn't seem to work however I am going to try it again with the main code.