Did you try recording a new macro when you do it manually?

uk wrote:

this code worked before but now it dosn't i found it in a previous timesheet
vba

Private Sub Workbook_Open()
Workbooks.Open Filename:="D:\lorne stewart\timesheet\2008\data.xls"
End Sub

"Dave Peterson" wrote:

That wasn't the last response.

uk wrote:

'run-time error 1004' comes up

"Dave Peterson" wrote:

You didn't post a response to the last suggestion at your other post.

uk wrote:

both work books are in C:\
the master workbook name is test
the slave workbook name is data

--

Dave Peterson
.


--

Dave Peterson
.


--

Dave Peterson