Excel & a .JPG file

Question posted by: harshadd (Familiar Sight) on July 25th, 2008 12:21 PM

I have a JPG file, and an EXcel sheet sheet1 of Book1 with default settings.I am inserting .JPG on the sheet 1and stretching it by keeping aspect ratios same. so that Pict occupies maximum of spreadsheet but keeps the height v/c width proportions same.
Now that pict is enlarged.
Now suppose a verry small part of the picture covering cell A1 is having colour red RGB(255.0.0) then I want cell A1 feeled by RGB(255,0,0)
I can run following code to change the cell colour
Sub Macro1()
Range("A1").Select
With Selection.Interior
.Color = RGB(255 0, 0)
.Pattern = xlSolid
End With
End Sub
but need to know what is the color to set. Can any one tell how can I link between cell Name and the part of picture covering it?

You can guess now what will happend if all cells are changed with the respective colors of picture covering them...

harshadd

Familiar Sight

132 Posts

July 29th, 2008
06:07 AM
#2

Re: Excel & a .JPG file

ANY ONE? Try to solve this ...
I want this to result in an Excel spreadsheet with an Image PIXELIED on cells of the sheet, so that if you seen the entire worksheet by reducing its view to (say) less than 10% then u can see and recognize the original picture.
In normal view only colour full cells will be seen and no 1 can make out what is it till they see it in reduced size of view.

Give a try.. Its a fun. I know it may not add any value to day-to-day life but still.. I am trying my best on this. I will let u guys know if I could do that...
Rgds
harshadD

Not the answer you were looking for? Post your question . . .
189,169 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment

Top Visual Basic Forum Contributors