View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Keith Willis Keith Willis is offline
external usenet poster
 
Posts: 10
Default Ghost excel process

The problem was the active cell reference in

xlWBSource.Sheets(1).Cells.Find(What:="Service Line",
After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows,
SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate

just needed to prefix it with the instance of excel i.e.
After:=myExcel.ActiveCell