I'm having an issue importing some data from a web site. The bulk of the stuff I want is one one page which is nice and simple. There is a portion, however, that runs 6+ pages and is java or flash based so when I import external data it only pulls from the first page no matter what. On this site there's an option to export the data to excel which is nice because I can then copy and paste that data into the sheets I need it in. Problem is, I've got everything else set to update at the click of a button and have to keep visiting the site to open the excel docs, copy and paste. Is there a way to create a macro to visit the site, navigate to the page(s) I want, open the excel doc and copy and paste the data or am I SOL?
Any help or suggestions would be great.
Any help or suggestions would be great.