I'd like an Excel spreadsheet coded that uses the ebay API to extract details of auctions in progress using set criteria.

I'd like to be able to store multiple searches in a single worksheet (1 search per line) with each search to include the following variables

1) Search Title (User Defined Value)


2) Category (inc Child Categories)


3) Keywords


4) Expected Sale Price (This isn't an ebay value)

I'd like to be able to store all my keyword exclusions in a single worksheet (1 exclusion per line)

I'd like the search results to be in a single worksheet consisting of the results of all the searches added to the search worksheet and are to include the following data:

1) Search Title (from Search Worksheet)


2) Auction Reference


3) Auction Title


4) Current Bid


5) Postage Costs


6) Total Costs (Consisting of Current Bid and Postage Cost value added together)


7) Expected Profit (calculation based on "Expected Sale Price" in the search worksheet, less the "Total Costs" value in the search results

I'd also like the following filters to be applied to the search results

1) If the auction title includes a value from the Keyword Exclusions worksheet, then it is to be excluded


2) If the Expected Profit figure is < 1 then it is to be excluded


3) If the time to the end of the auction is > 24 hours, then it is to be excluded.

Please only bid if you have experience of working with the Ebay API and VBA

Thanks Additional Info (Added 12/5/2009 at 4:35 EST)... I'd also consider a small webpage that provides the same functionality if it's not possible to do this in excel Additional Info (Added 12/12/2009 at 19:24 EST)... System Message: This is a reposting of project Ebay API Project. (1259969715).