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

Then drag fill down your column.

--
Regards,
Tom Ogilvy

"Grey" wrote in message
...
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