Project Detail

Description

I'm looking for an expert in programming in VBA in Excel to write code that will do the following for me. I want the code to be very clean, fast, and well-written.

1. I have a table of inventory. Colors down the size, Sizes across the top. I'd like VBA code that first "prepares" the table in a certain way; then exports it to an image file; then uploads that image to a website via FTP. Steps:

Prepare - please see attached PDF for example:
a. Delete rows for colors w/o any inventory
b. For each color (each row), I have that color's hex value. Using this, I'd like the macro to set that row's background to equal the color matching the hex value.
c. According to how dark the color is, toggle the text to white (or keep as black).

d. Export the table to an image file (GIF or JPG)

e. Upload that image file to a website via FTP.


2. Write a module that goes down a list of USPS tracking numbers, querying the site for each, and downloading the following info to a spreadsheet, next to the numbers:
-The class (first class, etc)
-Current status
-The date when it was mailed (The date for "Electronic Shipping Info Received")
-The date when it was rec'd (if it was yet)

Here's an example of # that has arrived:
http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=9101785091401150751740

Here's an example of a # still in transit (as of this writing...)
http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=9101128882300848302877

Thank you.


Additional files submitted:
Book3.pdf