Help...........record a macro

Note the part about adding the Developer Tab to the Ribbon.


Gord Dibben MS Excel MVP


On Mon, 30 Nov 2009 15:08:02 -0800, uk
wrote:

how do i record a new macro msoffice excel 2007


"Dave Peterson" wrote:

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
.