Hello All,
I crossposted it to UtterAccesForums as well.
Does anyone know a method to resize external pictures (mainly jpg, png) using VBA?
In one of my projects I need to store pictures for inspections. Button click opens FileDialog, user searches for file which is then copied to specific folder and path to it is stored in db. What I want to do is: before copying it to db folder I'd like to check if it's longer dimension exceed some set size (let's say 2500px) and if it does, reduce longer edge to 2500px keeping proportions of course and save new file as jpg in desired folder.
Anyone has some proven methods to do this kind of stuff?