R
Rod Armour
I'm having trouble with the SendKeys command in Excel 2002 (Win2k). I
am trying to send commnands to a Win2k dialogue box (Power Option
Properties), but the SendKeys command "^(TAB)" does not change tabs in
the dialogue box like it does when typed manually on the keyboard.
(According to Excel VBA help, "^(TAB)" = Ctrl+Tab). I have tried
numerous other Sendkeys commands, but none of them act like Ctrl+Tab.
Does anyone know how I can change tabs in a windows dialogue box using
SendKeys? Or how I can get Win2k to interpret SendKeys commands
"correctly"? Failing that, does anyone know how to turn hibernate on
and off using an Excel macro?
Part of my simple script:
Set WshShell = CreateObject("WScript.Shell")
WshShell.SendKeys "^{ESC}", True 'presses the Start button
Application.Wait Now + TimeValue("00:00:01")
WshShell.SendKeys "{DOWN}", True 'highlights a link to Power Option
'Properties
Application.Wait Now + TimeValue("00:00:01")
WshShell.SendKeys "{ENTER}", True 'opens Power Option Properties
Application.Wait Now + TimeValue("00:00:02")
WshShell.SendKeys "^{TAB}", True 'problem is here, this does NOT
'switch tabs within the dialogue box!
Any help greatly appreciated ... Many thanks,
Rod Armour
am trying to send commnands to a Win2k dialogue box (Power Option
Properties), but the SendKeys command "^(TAB)" does not change tabs in
the dialogue box like it does when typed manually on the keyboard.
(According to Excel VBA help, "^(TAB)" = Ctrl+Tab). I have tried
numerous other Sendkeys commands, but none of them act like Ctrl+Tab.
Does anyone know how I can change tabs in a windows dialogue box using
SendKeys? Or how I can get Win2k to interpret SendKeys commands
"correctly"? Failing that, does anyone know how to turn hibernate on
and off using an Excel macro?
Part of my simple script:
Set WshShell = CreateObject("WScript.Shell")
WshShell.SendKeys "^{ESC}", True 'presses the Start button
Application.Wait Now + TimeValue("00:00:01")
WshShell.SendKeys "{DOWN}", True 'highlights a link to Power Option
'Properties
Application.Wait Now + TimeValue("00:00:01")
WshShell.SendKeys "{ENTER}", True 'opens Power Option Properties
Application.Wait Now + TimeValue("00:00:02")
WshShell.SendKeys "^{TAB}", True 'problem is here, this does NOT
'switch tabs within the dialogue box!
Any help greatly appreciated ... Many thanks,
Rod Armour