Opening XLSM file [SOLVED]

Hi all,

I have a code where i need to open a other workbook. I works fine with .xls files, but when im trying to open a .xlsm file i just get a error? Anyone can see why?

Code:

---


Private Sub CommandButton1_Click()
Dim i As Integer
Dim pw            As String
Dim path            As String
Dim clor            As String
 
Application.ScreenUpdating = False

With ListBox1
For i = 0 To .ListCount - 1
If .ListIndex = i Then pw = Range("B" & i + 4).Value
If .ListIndex = i Then path = Range("G" & i + 4).Value
If .ListIndex = i Then clor = Range("I" & i + 4).Select
Next i
End With
 
'ERROR COMES HERE!
    Application.Workbooks.Open Filename:=path

---

What is the error?

Are you using Excel 2007 (if you aren't, there is the problem)

Yes im using excel 2007, its error 1004 i get. And the debug mode marks this line

"Application.Workbooks.Open Filename:=path"

The 1004 error in vba is pretty generic. What was the error description? Are your macro security settings set to low?

Just changed some macro settings and it seems like it helped. Thanks to all you guys!