I don't know if this will interest anyone but I have a excel spreadsheet that I'm working on to help me with some html coding & in particular with colouring.

Bob Stein over at www.visibone.com was gracious enough to let me replicate his hex colour chart.
The screenshot below shows the current progress.

Essentially I've got all 216 websafe colours attached to hexagonal clickable image thingies (my technical expertise is shining through) - each single tile (yes it took a while) has a separate macro which simply puts the corresponding hex colour code into the hex colour code cell - the RGB code is calculated from that. A second macro (which is currently blank) is then set to run which can be programmed to do whatever you want.

So what is it good for?
One of the things I've been playing with today is tables & on the page link below you see for better or worse how it's gone... I'm not entirely happy with the colouring.

I'm setting up a table in the spreadsheet where I can test different colours of the different table components by simply clicking on the colours & having the second macro automatically update the table appearance.

The currently "blank" buttons can be set to anything you want.
The macros you create for each should all input their values to one particular cell.
The idea then is that the second macro that each of the 216 colour macros runs will look at the value of that particular cell & run a different function accordingly.

For example in the table thing I'm yet to start on, I might have say 5 buttons - table border(1), header background colour(2), header font colour(3), rest of the table background(4) & font colours(5) - obviously I'll probably have more... and an area with a table set out with some headers & values

If I click on the table border button it will put a 1 in a particular cell, header background it will put a 2 in that cell & so on.

When I click on any colour then, it will put the corresponding colour into the hex colour code cell, run the second macro which will then see from the particular cell what part of the table you've selected to change & change it on the preview table.

If you are really keen it's quite easy then program the spreadsheet to produce the relavent code to copy across to your editor.

There are literally endless applications & maybe it's something that will interest someone out there in forumland... maybe someone's had a little too much coffee & can't get to sleep any time soon.

Obviously you'll need excel & if you want to try your hand at any of the above you'll need 2007 or 2010 as 2003 & earlier won't handle the colours. I keep my computer clean but it's good practice to scan before you download. You'll also need to trust my macros if you want to use them. Otherwise it's still just pretty to look at...

This is all the macros look like if you are worried.
--------------------------------------------
Sub Macro2()
'
' Every HexCode Macro will the run this Macro so you can make it do whatever you want
' If you want to change the name you'll just need to do a search & replace
'
' Special thanks to Bob Stein at Visibone.com for the colour arrangement

End Sub
--------------------------------------------
Sub HexCode_000000()
Range("G27").Value = "000000"
Application.Run "Macro2"
End Sub
--------------------------------------------
Sub HexCode_000033()
Range("G27").Value = "000033"
Application.Run "Macro2"
End Sub
--------------------------------------------
and so on for another 214...

There is no protection on anything so you can change & edit to your hearts content. The logo just links back to my website.

For the excel file, click on this link & then on the screenshot to download the file.
http://www.thelittlecashbookcompany.com/stamps_plain.html

Anyone know how to record numbers of downloads?
Thanks!

http://i1140.photobucket.com/albums/n565/RobbieNoordzy/The%20Little%20Cash%20Book%20Company%20-%20Designs/TheLittleCashBookCompany-CodeGeneratorwithColourPicker.jpg

While all 216 hexagonals are seperately clickable they have been grouped together (that was another nightmare!).
Simply right click on any of the hexagonals, left click on anything other than the options that come up. There'll be a box surrounding them all now. Left click & hold anywhere along the box (apart from the bits that re-shape/rotate) then drag to wherever you want it to go.

Thanks Robbie. Excel rocks. I use it all the time. Always interested in what others are accomplishing with it.

That's so tech over my head lol, why not just use the Web Color Schemer by CC? That's like my right hand app for anything to do with color. Gives you every piece of information you need about a color, allows you to copy the Hex code to input into other apps and files and code etc. Gives you the ability to build color schemes, pull color schemes from images, you name it.

I'm sure there's an excellent reason for your color setup, but it's so high tech over my head (and I'm sure many others) that I can't think of anything I could use it for that I don't already use a CC program for. Just sayin'

It's an Excel thing.

Well yeah I get that part, but I guess I don't get what the purpose of it is. Like I said, I tried to read the post, but I lost it half way through it lol. Sorry not a programmer at all so I guess it's over my head anyways, just wondering why the CC color schemer wouldn't be able to be used for the same thing unless it's some kind of integration I am not understanding? It's all good though, just speculating the differences I guess.

I downloaded it and will see if it assist me in working with some of my customers in selection colors for their websites. Often they like to point to colors on their walls, pictures or coffee cups and say that one. Then a take a picture and use a color picker tool to determine the color codes.

Thanks Rolly! I love excel too.
I work in an accounting office I use it every day for work. When 2000 rolled around our then ancient accounting software (15 years old with 0 updates in all that time) would not roll over so I wrote spreadsheets to handle everything bar our tax return processing.

Sorry Jo, like Rolly said, it's an excel thing. I made it long so anyone remotely interested (and into excel) would know what I've done/planned... hopefully!

It's certainly not meant to replace the colour picker. What it will do (not yet, as I've just got up & have to get the kids ready for school... then go to work) that colour picker doesn't is automatically show how those colours will look on the different components of a web project all together.

Hey Larry, thanks for the interest. Might not help yet in it's current form but if you are interested in playing with excel then go for it.

I use excel at work for production, accounting, scheduling, inventory, water withdraw tracking, fertilizer calculations, micro nutrient injection rates, sulfuric acid calculations, signage printing, loading ticket printing, cutting and seed ordering, label printing, energy usage tracking, pulling ticket generation and now Hex code color picking.
I have made a few other apps with Excel and Word for my sister to use at her job for logistics and cubing out trailers. I'm currently helping a plant material broker make a cutting schedule and ordering workbook. Taking a look at the back end of an Excel application helps me build better apps.

Like Jo I have the HTML Editor. I also have the very same thing in a Programming IDE I use but doing it in Excel is neat. I tried it great macro


If you are into macros try adding this to top of a page and rename the page extension to php



This is a project I am working on. It will write to a csv file
This only checks hits on a page but if the page is just for downloads it is an indicator. What you ask for is something I may think about. This is as close as I come at the moment