AXISHK
asked on
Excel Macro
I have a column that contain the link of a photo (eg. n:\myPhoto\xxxx.jpg). Any idea how to write a macro such that it can replace the text file with a actual photo and resize it to a particular width and length, Tks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
how big the photos pixels are? the width and height?
ASKER
787 x 787 , size 248KB.
Tks
Tks
I've requested that this question be deleted for the following reason:
The question has either no comments or not enough useful information to be called an "answer".
The question has either no comments or not enough useful information to be called an "answer".
I thought my answer actually answered the question.
The question and my answer are:
Question: Any idea how to write a macro such that it can replace the text file with a actual photo
Answer: ActiveSheet.Pictures.Inser t(cells(1, 1)).Select
Question: and resize it to a particular width
Answer: Selection.ShapeRange.Scale Width 0.3, msoFalse, msoScaleFromTopLeft
Question: and length,
Answer: Selection.ShapeRange.Scale Height 0.3, msoFalse, msoScaleFromTopLeft
The question and my answer are:
Question: Any idea how to write a macro such that it can replace the text file with a actual photo
Answer: ActiveSheet.Pictures.Inser
Question: and resize it to a particular width
Answer: Selection.ShapeRange.Scale
Question: and length,
Answer: Selection.ShapeRange.Scale