| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get column values from other excel file in VBA
='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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autosum column values, if separate column values equal certain val | Excel Worksheet Functions | |||
| How do i add a column of values based on another column in excel | Excel Worksheet Functions | |||
| How do I convert an excel file into a comma separated values file | Excel Discussion (Misc queries) | |||
| How do I change *.CSV excel file to column seperated file? | Excel Discussion (Misc queries) | |||
| Copy values from file A, Find/Replace these values in File B | Excel Programming | |||
Linear Mode
