0
I am developing a PRODUCT ORDER in Excel, via VBA. In this order, in addition to the description of the Product - item by item, I have the sizes of the same (I have already done); However I am not able to bring to this PRODUCT ORDER, the photos of the products themselves (each product has its photo).
For the first item of the Product Order, I have already managed to do it, but I am not able to get these routines done item by item.
The line of code I’m using is as follows::
fotoBDProduto = Application.GetOpenFilename(FileFilter:="Image Files(*.jpg), *jpg")
shtPedidos.Image1.Picture = LoadPicture(fotoBDProduto)
Where:
fotoBDProduct = folder or path where the product photos are
Image1 - is the place where the photo should be on request (first item) Image2 - is the place where the photo should be on request (second item) and so on (but this is where I’m not getting it done)
NOTE: This code is inside an Inclusion Form - Via VBA for Excel.
How to proceed with the code in this case...?
In order to complete the application, at least 40 photos must be inserted for each order. Where each photo means an item of this product.
Read this
– user28595
Related questions: Macro to automatically search images and play in excel and Add photo in excel spreadsheet from local folder. As I understand it is similar to the answers of the links.
– danieltakeshi