Need to apply vlookup in current sheet with table array from another workbook

[deepak.sirsale]

Hello Everyone,

I hve devised a Macro in which i open the file using Application.GetOpenFilename method, and i do some activity in the opened worksheets

so; my problem is i want to add a vlookup in the opened worksheet using the table array from the workbook from which the macro is ran, my coding is as below. I beleive i made a mistake in defining the object for Workbook, Please help...!

attached is the sample file.Test.xls

[Kaper]

How about:

Please Login or Register  to view this content.

PS.

Please Login or Register  to view this content.

would be nicer and

Please Login or Register  to view this content.

on the very first line of the module is also a good idea.