Tezzies
02-24-2008, 04:33 AM
I have a sheet which is in a shared workbook. On open it loads a picture which should resize it self but wont because of the share limitations.
My only solution is to load the pictures into another workbook (which is not shared) and resize them here then save the pictures at the correct size. Which is H=98 W=72.
My problem is this---- Excel seems to save them in there original state ie. to big . Can vba phyically re-size a jpg or will I need to use a 3rd party tool.
Many thanks in advance
My only solution is to load the pictures into another workbook (which is not shared) and resize them here then save the pictures at the correct size. Which is H=98 W=72.
My problem is this---- Excel seems to save them in there original state ie. to big . Can vba phyically re-size a jpg or will I need to use a 3rd party tool.
Many thanks in advance