See Ron de Bruin's CopyPasteMerge section for retrieving data from
multi-workbooks and multi-worksheets.
http://www.rondebruin.nl/tips.htm
Gord Dibben MS Excel MVP
On Mon, 23 Jun 2008 16:45:01 -0700, ranswrt
wrote:
How would I copy a range of cells from one excel file to another?
Thanks
"StumpedAgain" wrote:
Sub Open()
Workbooks.Open Filename:="File Path here such as C:\MyDocuments\File.xls"
End Sub
You can then call information from the open file.
"ranswrt" wrote:
I have two excel files. How do I write a procedure in one file that will
open the other file and be able to access the data in that file?
Thanks