I have a table of inventory. Colors down the size, Sizes across the top. I'm trying to create a macro that "prepares" the table in a certain way; so I can then make a GIF or JPG out of it, and post it on my Ebay listings online to show a (perhaps even real-ish time) image of my inventory currently in stock for that item.
Here's what I envision. Any steps anyone could help with would be very appreciated.
1. Delete rows for colors w/o any inventory (not hard, i can do this)
2. 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.
3. According to how dark the color is, toggle the text to white (or keep as black).
4. Export the table to an image file (I'm guessing this isn't possible w/in Excel VBA, and I'll just have to do this manually, but on the off-chance it is I thought I'd mention it in case someone wants to blow my mind).
4. Upload that image file to a website via FTP (same here).
Thank you.
Here's what I envision. Any steps anyone could help with would be very appreciated.
1. Delete rows for colors w/o any inventory (not hard, i can do this)
2. 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.
3. According to how dark the color is, toggle the text to white (or keep as black).
4. Export the table to an image file (I'm guessing this isn't possible w/in Excel VBA, and I'll just have to do this manually, but on the off-chance it is I thought I'd mention it in case someone wants to blow my mind).
4. Upload that image file to a website via FTP (same here).
Thank you.
