Hi,

supposing that cell A1 contains path and filename (like "c:\test.xls").
you can use this code

sub OpenFile()
workbooks.open(range("a1").value)
end sub

To open the file "test.xls"
This is just basic code without error trapping.

Regards,
Ivan