Need a custom application to do the following while a computer running Windows XP/XP Pro is connected to the Internet:
a) Whilke running Excel (could also be Access), upload an Excel file, where Column A has the titles of DVD's, books, or videos. This title may be prefaced with a number in any of the following formats (using 1 as an example): 1 OR 1) OR 1. OR 1- OR 1:
b) Column B has the UPC # (optional)
c) Column C has the ISBN # (optional)
d) Column D has either a D or B or V for either DVD, Book, or VHS video
e) Return/download to Column E the lowest price for a new item matching UPC# first, then ISBN# second, and Title if neither UPC or ISBN are available.
e) If only Title is entered, there will be a range of possible solutions. Return up to the 1st Five results including the item name, lowest new price, lowest used price.