View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
[email protected] uk swain.s@blueyonder.co uk is offline
external usenet poster
 
Posts: 64
Default i want to open a second workbook automatically when i open the

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
.