I've set up a VB function which allows the user to select any picture file from their PC/network and insert it into the excel file, using the AddPicture method (intended to be their company logo). However, this method obliges you to specify the inserted picture's width and height, which inevitably means its original aspect ratio is lost.
Is it possibe to either tell the AddPicture method to keep the image at its original size and/or aspect ratio, or can the image be reset (via VB) to it's original size after inserting?
I've tried recording a macro which follows the Format Picture/Size/Reset method, which does reset the picture's original size, but the recording leaves specific values in the VB text string, not something like 'Reset' or 'Original'.
Any ideas?
Bookmarks