Opening XLSM file [SOLVED]

[maxkoy]

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?

 
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

[Hack]

What is the error?

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

[maxkoy]

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

"Application.Workbooks.Open Filename:=path"

[dmaruca]

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

[maxkoy]

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