I am developing a PRODUCT REQUEST in Excel via VBA. In this request, besides the description of the Product - item by item, I have the sizes of the same (I already did); However I am not able to bring to this PRODUCT ORDER, the photos of the products themselves (each product has its own photo).
For the first item of the Product Request, I have already been able to do it, but I can not make 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:
photoBDProduct = folder or path where the product photos are
Image1 - is the place where the photo should be in the order (first item) Image2 - is the place where the photo should be in the order (second item) and so on (but here is what I can not do)
NOTE: This code is within an Inclusion Form - Via VBA for Excel.
How to proceed with the code, in this case ...?
In order for the order to be complete, at least 40 photos must be inserted for each order. Where each photo means one item of this product.