I’m very new to VBA and appreciate any guidance.
From Excel, I need to access a website, populate form fields with values from a spreadsheet, click submit, and then return the value displayed on the new screen to the spreadsheet.
I need to do that for a list 100 rows on the spreadsheet.
I’ve used parts of examples I’ve found to get the browser open – and I can populate the form fields if I put the values in the code – but can’t seem to get it to look at the spreadsheet for values, let alone the balance of the requirement.
What do you think are my next steps? Thanks in advance for your help.