Completed

VBA Macro to get the narrowest width of the non-transparent area of PNG image in the X direction and Y direction

VBA Macro to get the narrowest width of the non-transparent area of PNG image in the X direction and Y direction

If the PNG image (which is listed in the Excel File) has transparent areas, then calculate the percent of the transparent areas and record it back to the excel file.

percent of the transparent areas = total transparent areas / canvas size of the PNG image

Example for the percent of the transparent areas:

The Canvas Size of a PNG image is 1000 * 1000 pixels, and it has one 100 * 100 pixels transparent area and one 200 * 200 pixels transparent area, then the percent of the transparent areas is:

(100 * 100 + 200 * 200) / (1000 * 1000) = 50,000 / 1,000,000 = 5%

If the PNG image (which is listed in the Excel File) has transparent areas , then get the narrowest width(Pixels) of the non-transparent area of PNG image in the X direction and Y direction(see the screenshot [login to view URL], B should be the narrowest width in the X direction, and A should be the narrowest width in the Y direction), and record the data back to the excel file.

If the PNG image (which is listed in the Excel File) has no transparent area, then skip it.

We will release the money to you after we test the macro with about 1,000 images within 5 days and the Macro meet all the requirements.

The code should not be encrypted, so that we can modify the code ourselves.

Skills: Excel, Visual Basic, Visual Basic for Apps, Image Processing

See more: vba macro excel unicode, excel vba macro paste adjacent column, next empty cell vba macro paste, vba macro trial, vba macro generate report excel word, paste excel vba macro, row column increment vba macro, vba macro click button webpage, excel vba macro databases, calling oracle procedure vba macro, vba macro perl, excel vba macro programming bids, deploy vba macro, excel 2003 paste clipboard vba macro excel, vba macro clean telephone number format, vba macro extract emails outlook, excel vba macro calculate business days, vba macro write text file hyphens, vba macro download yahoo finance, change global width autocad block vba macro

About the Employer:
( 20 reviews ) Essen, Germany

Project ID: #30495987

Awarded to:

(415 Reviews)
6.7

5 freelancers are bidding on average $31 for this job

DeveloperDanil

********************* Hello there! I read carefully your post. I have all the skills you need. I will finish as soon as possible and exactly and responsibly. Please give me a choice... Thank you. *********************

$60 USD in 2 days
(2 Reviews)
3.8
Blackeagle8

Hi, Kindly, I work on many projects like your request, I can send to you many samples of my work in Excel chart, Formulas, Pivot table, and VBA codes. Please let me have a chance to show you my experiences. Please, d More

$25 USD in 1 day
(4 Reviews)
1.8
bmoatar1

Hi, I am happy to bid on your project. I wanna carry out your project. I have full experience with **** VBA, Image Process **** ========================================================== I can carry out your project o More

$10 USD in 3 days
(1 Review)
0.4
ant0504

Hi, I've read your description carefully. I have more than 11 years experience with VB/VBA/Image Processing. ************************************************************************************* I'm confident in your p More

$30 USD in 1 day
(0 Reviews)
0.0