If I find the data in excel through word vba in mac, the find statement automaticaly closed the word document. But this coding is working in Excel vba. I don't know the problem please help me.
Coding :
Dim wb As Excel.Applicati on
Set wb = New Excel.Applicati on
wb.Workbooks.Op en (fullnameofxls)
wb.activeworkbo ok.Activate
dim aRange as Range
Set aRange = ActiveSheet.Cel ls.Find(What:=f ind_text, After:=ActiveCe ll, LookIn:=xlFormu las, LookAt:= _
xlPart, SearchOrder:=xl ByRows, SearchDirection :=xlNext, MatchCase:=Fals e)
If Not (aRange Is Nothing) Then
msgbox "Data Found"
Else
msgbox "Not Found"
End If
Coding :
Dim wb As Excel.Applicati on
Set wb = New Excel.Applicati on
wb.Workbooks.Op en (fullnameofxls)
wb.activeworkbo ok.Activate
dim aRange as Range
Set aRange = ActiveSheet.Cel ls.Find(What:=f ind_text, After:=ActiveCe ll, LookIn:=xlFormu las, LookAt:= _
xlPart, SearchOrder:=xl ByRows, SearchDirection :=xlNext, MatchCase:=Fals e)
If Not (aRange Is Nothing) Then
msgbox "Data Found"
Else
msgbox "Not Found"
End If