Loop Excel macro code

[pradisdeep]

• I am unable to loop the below code with the above given example... need help !!!
  expandcollapse popup

  _WinWaitActivate("Microsoft Excel - Book2","Status Bar")
  Sleep(500)
  Send("!H")
  Send("C")
  Send("C")
  Sleep(500)
  _WinWaitActivate("BAR.BMC - Process Account - (BNJ/BNJ.LIVEN/BNJ.LIVEN) - Predee - \\Remote, 256-bit SSL/TLS.","")
  MouseClick("right",160,153,1)
  Send("{DOWN}{DOWN}{DOWN}{DOWN}")
  Sleep(500)
  Send("{ENTER}")
  Sleep(1000)
  Send("{ENTER}")
  Sleep(2500)
  Send("{ENTER}")
  Sleep(2500)
  MouseClick("left",1169,603,1)
  Sleep(2500)
  MouseClick("left",791,128,1)
  Sleep(2500)
  MouseClick("left",314,839,1)
  Sleep(2500)
  _WinWaitActivate("BAR.BMC - Enter Comment - \\Remote, 256-bit SSL/TLS.","")
  Sleep(2500)
  MouseClick("left",171,349,1)
  _WinWaitActivate("Microsoft Excel - Book2","")
  MouseClick("left",124,197,1)
  Sleep(2500)
  Send("!H")
  Send("C")
  Send("C")
  _WinWaitActivate("BAR.BMC - Enter Comment - \\Remote, 256-bit SSL/TLS.","")
  MouseClick("right",146,345,1)
  Sleep(500)
  Send("{DOWN}{DOWN}{DOWN}{DOWN}")
  Sleep(500)
  Send("{ENTER}")
  Sleep(1000)
  _WinWaitActivate("Microsoft Excel - Book2","Status Bar")
  Send("{LEFT}")
  Send("{DOWN}")
  Sleep(500)

Edited July 18, 2014 by Melba23
Amended title

[Melba23]

pradisdeep,

Welcome to the AutoIt forums.

We prefer people not to necro-post in 6 year old threads. Much better to open a new thread and link to the old one.

We ask you to do this for two main reasons:

 

- 1. The language advances and the functionality might well be included in core or UDF code by now

- 2. The changes in language syntax mean that it is likely that code from more than a couple of years ago may well not run under the current release interpreter without significant modification.

And as there is now a very good Excel UDF in AutoIt I am sure you will be able to do what you want to do much more easily using that then depending on send & Mouseclick.

M23

[water]

As Melba noted it is (most of the time) better to use the API provided by the program you try to automate than to automate the GUI using Send etc.

So please have a look at the Excel UDF and don't hesitate to ask if something is unclear

Edited July 18, 2014 by water

[Melba23]

water,

Good evening. I thought the new thread title might attract your attention!

M23

[water]

That's correct, Melba. As always