VBA and Multiple Excel Files

Hi Matthew

If you want to open a closed workbook from another workbook to then copy values from it you write the following code:

Application.Workbooks.Open "C:\My Documents\Accounts\2008 Accounts.xls"

The full path of the Workbook's address can be found using Windows Explorer and copied in. The path is a string.

The Workbooks.Open method also allows you to set other Worksheet values like passwords

Hope this helps

Carlos