Excel files

[ranswrt]

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

 

[StumpedAgain]

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]

How would I copy a range of cells from one excel file to another?
Thanks

 

[Gord Dibben]

See Ron de Bruin's Copy>Paste>Merge section for retrieving data from
multi-workbooks and multi-worksheets.

http://www.rondebruin.nl/tips.htm


Gord Dibben MS Excel MVP