How to automate a dynamic web page using VBA?
May 9, 2012 10:32 AM Subscribe
Help me automate some of my work involving taking values in a spreadsheet and plugging them into a website with dynamically generated content.
posted by Reverend John to computers & internet (6 answers total) 2 users marked this as a favorite
I need someone to point me in the right direction. I have several tasks which are very mechanical which I would like to automate. One, for instance, involves taking a list of product numbers from a spreadsheet, entering them one at a time to a website, then printing the resulting page.
Basically the page I want to use is dynamically generated, but the parts I want don't show up until after the necessary info has been entered, and I can't get the page to recognize that I've automatically entered it. Further complicating the situation is that the web page I'm working with is generated by ASP (I think) which I'm not familiar with and which is inserting a lot of strange script tags with long strings of encoded data.
Any help or pointers in the right direction would be greatly appreciated.