pictures into excel

[mrExl]

hi,
I used excel 2016 or office 365. I use VBA insert picture. Need to reduce the size like 60x60 times or so.
Does not work well with a bit dark tif files. I tried bright + contrast in VBA and it helps but not quite visible.
What is the best code to insert tif image with that kind of size reduction in VBA or Vbscript?.

 

[jolivanes]

what is the code you have used so far, to import the picture, to resize it and to change the brightness?

 

[Logit]

Why not manipulate the image prior to inserting into Excel ?

 

[mrExl]

How do i manipulate the image?. it is 16 bit. I could convert to jpg?.

my vbscript does not recognize msoFalse.

[B]Set pic = ActiveSheet.Pictures.Insert(tifPicture)[/B]
set picrange = ws.Range(A1:C10)

With pic
.Height = picrange.Height
.Width = picrange.Width
.Top = picrange.Top
.Left = picrange.Left
[B] End With[/B]

 

[Logit]

You would need to utilize an image software package. Surprisingly MS Paint may have just enough options to accomplish your goal.

 

[mrExl]

could you provide some detail. what kindsof image processes to apply in paint??.

 

[Logit]

I misspoke regarding MS Paint. Forget that as an option.

If you go to the MS Store (should be an icon on your Task Bar at the bottom of your monitor) and search for 'IMAGE EDITOR". There
are many FREE image editing programs that can be downloaded. Look them over and select one. I enjoy editing images for my
Excel projects ... hopefully you will too.

 

[jolivanes]

I use the free and highly regarded IrfanView.
If you do go that way, install it with all the bells and whistles, aka plug-ins, as recommended at the IrfanView site and play around with it.
If you're not happy with it, all you have to do is uninstall it.