this is a code from MACROS MADE EASY

Sub Workbook_Open()
Workbooks.Open("data.xls")
End Sub

"Gord Dibben" wrote:

Not if you did not add more to it.

Show us the code you tried that does not work.


Gord Dibben MS Excel MVP

On Thu, 26 Nov 2009 09:20:01 -0800, uk
wrote:

hi i have tried the code that you recommended but i cannot get it to work

"Dave Peterson" wrote:

dim wkbk2 as workbook
set wkbk2 = workbooks.open(filename:="c:\somefilename.xls")


uk wrote:

--

Dave Peterson
.


.