Macro to click Cmnd Button in HTML

February 26, 2009 at 10:48:04
Specs: Windows XP
This is a long one: I created a Macro in Excel that opens an HTML doc and 'click' on a command button at my specified time (based on PC clock). I did this by using ***Sendkeys "{Tab}" ,True*** to 'Tab' though the various command buttons and I sendkeys 'Enter' to click it. It works great when I run it scheduled after a few hours but when I schedule it to run after say, 12 hours, it fails to send the 'Enter' key. How do I make it work or is there a another approach I can do to ensure that it 'clicks' the button no matter how long I schedule it for? Hope you guys can help...

See More: Macro to click Cmnd Button in HTML

Report •

February 26, 2009 at 10:56:13
some additional info: I also set up a rule in outlook so that when I send a message with a cerrtain subject it opens the Excel file, which then runs tha macro when it opens. The Macro in turn opens the HTML document, tabs through the command buttons until it 'highlights' the correct one and Sendkeys "{Enter}". When I try this with my PC unlocked or recently locked it works. But if I do this when I am out of the office the Sendkeys "{Enter}" part of it fails (same as the scheduled Macro). I need to be able to send an email to myself from out-of-the-office and 'click' the command button remotely. Thanks!

Report •
Related Solutions

Ask Question