pasting data from my clipboard to a different workbook

Question

I am using vb.net to copy a range of data from worksheet "A" using the following code:

'Set range of data to be copied
xlRng = xlsheet.Range("A2:k" & IntAmountOfRows)
xlRng.Copy()

'close source
xlWb.Close(False)
xlApp.Quit()

But when I do this, it asks the user if it wants to keep the huge amount of data on the clipboard. Is there a way to let the application skip this check? I dont want the user to get any annoying popups when they will press yes anyway.

score 1 · Accepted Answer · edited May 23 '17 at 12:03

1

Application.DisplayAlerts = False should help out. See this SO question for more info. For a VB.net only solution, check this SO discussion.

edited May 23 '17 at 12:03

Community

1
1

answered Oct 04 '13 at 12:56

Aaron Thomas

5,054
8
43
89

1

@Gutanoth Use your `xlApp` instead of `Application`! – LS_ᴅᴇᴠ Oct 04 '13 at 15:00

pasting data from my clipboard to a different workbook

1 Answers1