Using Copy(Destination:=) to copy to a different Excel file

Question

I an using the

range.copy(Destination:= <destination>)

method in VB.Net

I know this function works if you want to copy to a different Sheet, But for some reason I can not find the right syntax to copy to a completely different Excel file

Please check this question stackoverflow.com/questions/19167939/… — Hiten004
– Hiten004, Commented Oct 4, 2013 at 13:31
possible duplicate of Is copy-and-paste coding ever acceptable? — Hiten004
– Hiten004, Commented Oct 4, 2013 at 13:31
I alreadyu found that question. However, that is VBA and the functions used there are not available in VB.Net This is most certainly not a duplicate of the second question. Im not asking wether or not I should copy my code, I am asking HOW to copy DATA from one workbook to another! — Gutanoth
– Gutanoth, Commented Oct 4, 2013 at 13:32

Community · Accepted Answer · 2017-05-23 10:28:17Z

1

Do you have two different workbooks open?

Dim wbXLsource As Excel.Workbook
Dim wbXLtarget As Excel.Workbook

wbXLsource = appXL.Workbooks.Open(strFileNameAndPath)
wbXLtarget = appXL.Workbooks.Add

Got this code from this post

Here is another useful link

edited May 23, 2017 at 10:28

CommunityBot

11 silver badge

answered Oct 4, 2013 at 13:41

Automate This

31.5k11 gold badges63 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Copy(Destination:=) to copy to a different Excel file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related