ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   In relation to coding (https://www.excelbanter.com/excel-programming/401014-relation-coding.html)

BOSS

In relation to coding
 
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


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com