poojavasti
New Member
This one is related to images
I have in my D drive a folder named Photo where
all the images are cumpolsary in jpeg format.
In excel in column A from A2 onwards I have the
Product Code. This code exactly matches with the
image name in the photo folder.
I want a product image added in the L column L2 onwards
of size 0.75 x 0.75 inches.
Any formula or code that automatically inserts
the image as I enter the Product Code in column A.
My product code will be like
ABC188
XYZ336
since my images are cumpolsary in jpeg format I do
not want to add extension i.e .jpeg in the product code.
thanks
I have in my D drive a folder named Photo where
all the images are cumpolsary in jpeg format.
In excel in column A from A2 onwards I have the
Product Code. This code exactly matches with the
image name in the photo folder.
I want a product image added in the L column L2 onwards
of size 0.75 x 0.75 inches.
Any formula or code that automatically inserts
the image as I enter the Product Code in column A.
My product code will be like
ABC188
XYZ336
since my images are cumpolsary in jpeg format I do
not want to add extension i.e .jpeg in the product code.
thanks