I like to create a button in a spreadsheet that would extract data from internet webpages and populate cells in spreadsheet. I want to automate the following steps:
1. type in a URL in IE
2. Save the source to a temp file
3. run a "function" to extract data from the temp file and populate a specific cell in a specific excel file or a table in an access db.
4. repeat steps 1 to 3 for all another 12 URLs.
I know enough to do step 3, but not how to incorporate 1 and 2 in the "function".
[Excel spreadsheet is not an absolute requirement. Using Access is an acceptable substitute.]