Sub Main()
Do
rc% = PS.WaitHostSettle(1000)
Loop While rc% = ERR_SESSION_BUSY
rc% = PS.SendString("btrh{Enter}")
rc% = PS.SendString("{NewLine}BA77{NewLine}")
rc% = AppWin.Paste
rc% = PS.SendString("{Enter}")
End Sub

If above is the code is it possibel that code imports data from excel and
run themacro inloop. The thing i wish to import is BA77 which is in the code.
Above macro is a recorded macro.

Kindly ask if unable to understand situation.
Thanks
Boss