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
|