An example of code to open another workbook

[afs24]

I'm trying to open another workbook using code. I just need a generic example of how to open another workbook using code.

 

[Mudface]

Try something like: -

Workbooks.Open "C:My DocumentsBook1.xls"

replacing the path and filename as required.

Also, take a look at the VBA help entry for Open for more info.