metamorphy
Programmer
Hello,
I am trying to find out how to simulate the insert\picture\from file option on the Excel toolbar using visual basic. I discovered the method AddPicture, but it requires parameters to specify the size of the image to be inserted. Is there a fuction that more exactly replicates the insert\picture\from file option on the excel toolbar so that the image which is imported maintains its inherent size. I am automating the process of importing .tif files created in Adobe Photoshop and I dont want to have to resize the pictures on the excel spreadsheet once they are imported. Also, I need to do this using only the Microsoft visual basic for excel software since I do not have the full VB package. Any suggestions would be greatly appreciated. Thanks.
I am trying to find out how to simulate the insert\picture\from file option on the Excel toolbar using visual basic. I discovered the method AddPicture, but it requires parameters to specify the size of the image to be inserted. Is there a fuction that more exactly replicates the insert\picture\from file option on the excel toolbar so that the image which is imported maintains its inherent size. I am automating the process of importing .tif files created in Adobe Photoshop and I dont want to have to resize the pictures on the excel spreadsheet once they are imported. Also, I need to do this using only the Microsoft visual basic for excel software since I do not have the full VB package. Any suggestions would be greatly appreciated. Thanks.
