How to get column values from other excel file in VBA

  • Thread starter Thread starter Grey
  • Start date Start date
G

Grey

Dear all

I need to get a range of column values from another excel. Can anyone teach me how to do that? is there any built-in function or is it possible to use "VLookup" function? If so, pls suggest the sample code for me.

Million Thanks

Eric
 
='C:\myfolder\[myfile.xls]Sheet1'!A1

Then drag fill down your column.

--
Regards,
Tom Ogilvy

Dear all

I need to get a range of column values from another excel. Can anyone teach
me how to do that? is there any built-in function or is it possible to use
"VLookup" function? If so, pls suggest the sample code for me.

Million Thanks

Eric
 
Back
Top