View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grey Grey is offline
external usenet poster
 
Posts: 16
Default How to get column values from other excel file in VBA

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