I'd like to be able to get my product price and stock updates to run as automatically as possible (I don't want to do a whole lot of work every time I update). I can download a csv, or tab delimited file from our supplier or they have a .php feed that is described below:

Code:
Product Download Help File
The purpose of https://shop.cwrelectronics.com/feeds/productdownload.php is to help you quickly update your database with fresh data from the cwr back-end server. Below is a list of required fields and a description of each one.
Required Variables

    * id
    * fields
    * delim
    * One of the following: time, sku, mfgn, ohtime

Optional Variables

    * invtype

id - A unique string that tied to your account. Your id is: MPB_MzUzNTkwMzUzNTkwNTMw
fields - Fields you want returned followed delimited by a comma
sku	CWR's Part Number
sdesc	Short Description
qty	Quantity Available to Ship
price	Your Cost
list	List Price
map	M.A.P. Price
mrp	M.R.P. Price
mfgn	Manufacturer Part Number
mfg	Manufacturer Name
upc	UPC Code
cat	Category Name
eta	Next Shipment Date
wt	Product's Shipping Weight
bh	Product's Box Height
bl	Product's Box Length
bw	Products's Box Width
fdesc	Full Description
acc	List of Accessories
st	Product Status (1 = Stock; 2 = Non-Stock)
pi	Accessories Included
wa	Product's Warranty
re	Product is a Remanufactured (1 = Yes; 2 = No)
ti	Title
delim - Format to be returned: xml, csv, tab, comma
time - Unix timestamp; all products that have changed after the time sent will be displayed
sku - Enter a CWR sku and have only that item returned
mfgn - Enter a Manufacturer Part Number and have only that item returned
ohtime - Unix timestamp; all products that had quantity on hand changed after the time sent will be displayed
invtype - Choose which kind of inventory to display (stock, nonstock, both)
disc - Will return discontinued items in the results. Fields EXCEPT SKU, MFG# with have the data replaced with NLA; if set to 1 example disc=1
Example https://shop.cwrelectronics.com/feeds/productdownload.php?fields=price,sku&delim=xml&time=1174276800&id=YOURID
We want to update our store on a (bi-) weekly basis using the Excel command vlookup to import info from the table we download from our supplier and we're able to do that manually with no problems. However, if anyone could help us come up with a macro that will import the new data using vlookup automatically that would be awesome. If the macro could even do the .php query to CWR so we didn't even have to download the initial Excel file from our supplier that would be even better.

I know this is kind of a odd question, but it has to potential to be a big time saver.

Thanks in advance for any help