Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
coding macro
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use the if statement for Macro coding? | Excel Worksheet Functions | |||
How to close a excel file using Macro coding? | Excel Worksheet Functions | |||
How to close a excel file using Macro coding? | Excel Discussion (Misc queries) | |||
Hidding Macro names and coding | Excel Discussion (Misc queries) | |||
soft-coding lines in a macro | Excel Discussion (Misc queries) |