[RESOLVED] closing an excel file from VB

[shadyattia]

I am extracting a column with 8760 cells from an excel file to my graph in my vb application. I managed to open and close the excell sheet from my program. However, when I try to run my application I receive this message:

There is a large amount of information on the clipboard do you want to be able to paste this into to another program later?

Is there a way that I can avoid receiving this message when calling the data from the excell file?

HOW??

[weirddemon]

You could just try clearing the clip board.

My.Computer.Clipboard.Clear()

[shadyattia]

I tried but to paste the code in vb but nothing happened. I think I need to paste it the the excel macro that I am calling. do you know any solution?

[weirddemon]

If the issue is that the clipboard is full, then clearing it will work. That means that you're not clearing in the right area.

[shadyattia]

Application.CutCopyMode = False

thank you

[fdunford]

In your App, try assigning your working variables to Nothing as soon as your done with them.

                xlSheet = Nothing
                xlBook = Nothing
                xlApp = Nothing

[weirddemon]

Application.CutCopyMode = False

thank you

Eh... whatever works

Please mark the thread resolved by selecting it from the Thread Tools menu located near the top of the page.