Getting Values From A Closed Workbook

[roshinpp_77]

can we write macro for getting values from a closed workbook and pasting to another excel file. If possible can it be used for getting values from multiple files?

This is extremely important..anyone wellversed pls revert

[colofnature]

See here:
http://j-walk.com/ss/excel/tips/tip82.htm

Col

[macropod]

See: http://www.j-walk.com/ss/excel/tips/tip82.htm

Cheers


"roshinpp_77" <[email protected]>
wrote in message
news:[email protected]...
>
> can we write macro for getting values from a closed workbook and pasting
> to another excel file. If possible can it be used for getting values
> from multiple files?
>
> This is extremely important..anyone wellversed pls revert
>
>
> --
> roshinpp_77
> ------------------------------------------------------------------------
> roshinpp_77's Profile:
http://www.excelforum.com/member.php...o&userid=34924
> View this thread: http://www.excelforum.com/showthread...hreadid=546661
>

[roshinpp_77]

Thanks Col for the useful reference...
regds,
Roshin

See here:
http://j-walk.com/ss/excel/tips/tip82.htm

Col