Web page Search via Access 2000

E

E Hines

I have an Excel spreadsheet that searches FreeEDGAR for
the SIC Codes of companies whose stock symbols are
provided to the search routine.

The Excel VBA code that does this is:

Call ClearSheet("scratch", "data")
Set ScratchSheet = Sheets("scratch")
ConnectURL
= "URL;http://www.freeedgar.com/search/companylist.asp"

PostStr = "SearchFrom=new&SearchWhat=" & TickerList _
& "&SearchHow=Ticker%
20Symbol&SearchTo=FreeEDGAR&image.x=10&image.y=10"

.PostText = PostStr

where TickList is the string of stock symbols.

How can I do this in Access VBA so my database can make
similar searches?

Thanks for your help.

Eric Hines
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IQY File: Invalid Web Query 2
Activate web link via image object 5
Search string to search for wild terms in Access database 0
Search any part of an Access recordset from Excel 1
FIX: Annoying inconsistent errors in Excel via Access automation 2
Fix: Annoying inconsistent errors in Excel via Access automation 2
Can't make Graphs in Access 2000 0
Help with altering a download macro 0

Top