I have two columns in an excel file A - contains the web link B - contains the data to be updated in opened browser as per A.
While opening in the web browser (1 as per image) there is drop down option comes at a particular section (2 as per image) > select an option > it will open up another form> update the data from column B and paste here (3 as per image) and Click Edit to complete the job. Then move to the next row in excel
I checked the support team to build something on the API, but it will take time also the imacro add on supports this iteration of activities however its a paid version. Can excel VBA possible to automate this
https://onedrive.live.com/?authkey=...6A&id=9CAF96913D9DF16A!156&parId=root&o=OneUp
While opening in the web browser (1 as per image) there is drop down option comes at a particular section (2 as per image) > select an option > it will open up another form> update the data from column B and paste here (3 as per image) and Click Edit to complete the job. Then move to the next row in excel
I checked the support team to build something on the API, but it will take time also the imacro add on supports this iteration of activities however its a paid version. Can excel VBA possible to automate this
https://onedrive.live.com/?authkey=...6A&id=9CAF96913D9DF16A!156&parId=root&o=OneUp
Last edited by a moderator:
