Help with modifying VBA Macro - Works fine but needs fine tuning !

[stefan27]

Below is VBA Macro Code that uploads images from Desktop Folder onto Worksheet. The code is Functional ie it works fine, but need some modification.

Please Login or Register  to view this content.

The code seems to ALTER the size of image during upload, which I DON'T want it to.

I have already created standard, uniform size of all images.

I simply want the code to pick the image & place it on Worksheet, without re-sizing it.

The Image size is 210 px X 150 px. - the code should also adjust size of Row Height & Col Width accordingly.

Anyone care to modify the code to remove that aspect of it's functionality ?

Thanks in Advance.

[p24leclerc]

You can try this:

Please Login or Register  to view this content.

There is code you could use to auto adjust the column width but it is more complicated.
If this is fine for you, go that way. A lot easier.

[stefan27]

Thanks - i'll try it out.

[stefan27]

I have attached Sample Excel, after running the code, unfortunately Output is not acceptable.

I can assure you that all the images in the Folder are ALL uniform, Standard size ie 210 by 150 px.

Yet some images are smaller ?!

[stefan27]

Ok -i've found a fix to the problem.

I am closing out this ticket.