G
Guest
I am using VBA code in Access to paste 1 column from workbook 1 to workbook 2.
This is the code that works by itself:
xlApp.Workbooks.Open(pathS).Worksheets("an_fb_diff").Range("A2:A237").Copy
destination:=xlApp.Workbooks.Open(path).Worksheets("an_fb").Range("A3")
I am unable to following it by another one because I am using the Open. I
wish to repeat the pasting from a different worksheet.
Can someone help me in indicating what I should replace the Open with????
I tried:
xlApp.Workbooks(pathS).Worksheets("cntl_fb_diff").Range("A2:A110").Copy
destination:=xlApp.Workbooks(path).Worksheets("cntl_fb").Range("A3")
The above gives me an error!!!
Help is deeply appreciated!!!
Gary
This is the code that works by itself:
xlApp.Workbooks.Open(pathS).Worksheets("an_fb_diff").Range("A2:A237").Copy
destination:=xlApp.Workbooks.Open(path).Worksheets("an_fb").Range("A3")
I am unable to following it by another one because I am using the Open. I
wish to repeat the pasting from a different worksheet.
Can someone help me in indicating what I should replace the Open with????
I tried:
xlApp.Workbooks(pathS).Worksheets("cntl_fb_diff").Range("A2:A110").Copy
destination:=xlApp.Workbooks(path).Worksheets("cntl_fb").Range("A3")
The above gives me an error!!!
Help is deeply appreciated!!!
Gary