Open file from address in a cell

[David P.]

Let's say that the value of cell A1 was "C:\Work Documents\David's
Folder\Schedule.xls" and I wanted to click a button to run a macro that
open's the file referenced in A1. Is that possible and if so how can it be
done?

The value of A1 would change continually so the macro could not always
reference "C:\Work Documents\David's Folder\Schedule.xls" for example.

Many thanks.

 

[Mike H]

Try

Workbooks.Open Filename:=Sheets("Sheet1").Range("A1").Value

Mike