How to create the VBA in order to vlookup for two different excel files

[umeed]

Hi ,
I am new in VBA and need assistance.
Is it possible to create a VBA code in order to Vlooklup two different excel files.
and then i want that result to be copied to third excel file.

i use below vlookup method
=VLOOKUP(A2,[SecondFile.xlsx]Sheet1!$A$1:$D$9,4,FALSE)

and i want same to be done via VBA and then it should give results in all cells

 

[Deepak]

Welcome to the board!

You might looking something like this.

Range("B2:B6") = "=VLOOKUP(A2,[SecondFile.xlsx]Sheet1!$A$1:$D$9,4,FALSE)"

 

[umeed]

Thanks Deepak,

But how to call that separate excel files via VBA code

 

[Deepak]

Check this..

http://stackoverflow.com/questions/15658334/vba-vlookup-across-workbooks


http://stackoverflow.com/questions/23528909/vba-vlookup-formula-refering-another-opened-workbook

http://www.mrexcel.com/forum/excel-...ic-applications-vlookup-another-workbook.html

 

[umeed]

One more query..is there a way to select the row and cloumns dynamically.
For example..if i am not sure how many rows and columns are non-empty and therefore if i want to select the range of non-empty cells,please advise how can this be achieved using VBA.

 

[Deepak]

You may use currentregion or usedrange