L
Legacy 165086
Guest
Hi All,
I have recently upgraded to Excel 2007 from Excel 2000 and am trying to run a macro. I get the following error:
"Error 445: Object doesn't support this action"
From a bit of searching I found that 'FileSearch' is not Supported in Excel 2007 onwards. I did a search in my code and came across an instance of 'FileSearch' being used:
With Application.FileSearch
.NewSearch
.Filename = PlanName
.LookIn = dir
.Execute
If .FoundFiles.Count = 0 Then
MsgBox "Plan File does not exist or Directory is incorrect"
ActiveWorkbook.Close Savechanges:=False
Exit Sub
End If
End With
Can someone point me in the direction of a resource that would help me to convert this code into something that would work with Excel 2007?
Thanks
I have recently upgraded to Excel 2007 from Excel 2000 and am trying to run a macro. I get the following error:
"Error 445: Object doesn't support this action"
From a bit of searching I found that 'FileSearch' is not Supported in Excel 2007 onwards. I did a search in my code and came across an instance of 'FileSearch' being used:
With Application.FileSearch
.NewSearch
.Filename = PlanName
.LookIn = dir
.Execute
If .FoundFiles.Count = 0 Then
MsgBox "Plan File does not exist or Directory is incorrect"
ActiveWorkbook.Close Savechanges:=False
Exit Sub
End If
End With
Can someone point me in the direction of a resource that would help me to convert this code into something that would work with Excel 2007?
Thanks