<p>I'm in need of a macro that will enter data into a webpage search field and than copy the results to excel.</p>

It's just a simple "File Open". No need for a macro.
Excel can open URLs directly. If the URL contains any tables, those will be formatted appropriately.
Try this:
Run Excel
File | Open
Type
```
http://finance.yahoo.com/q?s=MSFT
```
as the file name
Ignore the warning