09-09-2022, 11:15 AM
(This post was last modified: 09-09-2022, 11:20 AM by Fulham Fallout.)
(09-08-2022, 06:14 PM)Old Stroller Wrote:(09-08-2022, 04:54 PM)Fulham Fallout Wrote: I wonder if you can help me please.
I'm trying to write a bit of VBS code in Excel to populate web forms
The website is similar to this one with a login and then I want to be able to send private messages
I'll bet you do.
Can't help with the technical stuff though, sorry.
You have a PM.
Sent by a macro course

(09-08-2022, 05:53 PM)waffle Wrote: A = driver.findelementbyclassname(‘input box class name’)
A.send_keys(‘hello’)
Something like that anyway. I’ve tended to use python rather than vb
Hi
Thanks for that.
I eventually discovered that shell opening websites in VBA are not the active page and I therefore was unable to populate the form.
I removed the shell function and called each url listed in the spreadsheet and it now works a treat.
I've learnt quite a bit coding this including website HTML structure and all the different ways of locating web elements.
Thanks again for your suggestion
