Hello,
Would be extremely grateful if anybody could help me with this.
I'm trying to automate some work tasks using Excel VBA to run reports off a website. I'm teaching myself as I go and have automated the access, navigation, clicking buttons with ID's but am stumped on this and getting nowhere fast 'Googling' it.
I have a button I need to click which doesn't have an ID like other ones I have encountered. The element for it appears as below:
I'm trying to understand HTML code as I go but am unsure on this. From what I have read I believe it may be you can reference it by name or it may be a form that needs to be submitted. On the web site it appears as a click button.
Can anybody point me in the right direction of how I reference it in VBA to 'click' it please ?
Thanks
Would be extremely grateful if anybody could help me with this.
I'm trying to automate some work tasks using Excel VBA to run reports off a website. I'm teaching myself as I go and have automated the access, navigation, clicking buttons with ID's but am stumped on this and getting nowhere fast 'Googling' it.
I have a button I need to click which doesn't have an ID like other ones I have encountered. The element for it appears as below:
HTML:
<input name="csvset" title="Export" class="btn" type="submit" value="Export">
I'm trying to understand HTML code as I go but am unsure on this. From what I have read I believe it may be you can reference it by name or it may be a form that needs to be submitted. On the web site it appears as a click button.
Can anybody point me in the right direction of how I reference it in VBA to 'click' it please ?
Thanks