Christadelphian
Technical User
Hello All,
Can anyone tell me how I can send the equivalent of 'a user pressing the TAB key on the keyboard' through to Explorer from a macro written in Excel please?
I'm not sure if Sendkeys is a valid VB command or element opton for an IE window.
I am using the following code to change the Index Selection for a drop-down box, however I then want IE to tab to another INPUT box on the current page, and send further keystrokes to this INPUT box.
Explorer.Document.Forms.Display.Status.SelectedIndex = 1
So the name of the form is Display, and the name of the Drop-down box is Status, however the next element on the current web page shares its name with several others - hence why I'm unable to reference it directly.
Any ideas? Thanks in advance if you are able to help.
Can anyone tell me how I can send the equivalent of 'a user pressing the TAB key on the keyboard' through to Explorer from a macro written in Excel please?
I'm not sure if Sendkeys is a valid VB command or element opton for an IE window.
I am using the following code to change the Index Selection for a drop-down box, however I then want IE to tab to another INPUT box on the current page, and send further keystrokes to this INPUT box.
Explorer.Document.Forms.Display.Status.SelectedIndex = 1
So the name of the form is Display, and the name of the Drop-down box is Status, however the next element on the current web page shares its name with several others - hence why I'm unable to reference it directly.
Any ideas? Thanks in advance if you are able to help.