Hi,

I need to use a value of a cell in a spreadsheet in a macro command to copy
data.

For Example.

cell A1 = 28/09/2009

Sub

Workbooks.Open Filename:= _ "C:\(Value from A1)"

End Sub


Thanks,

Tom