PRODUCT REQUEST in Excel with Product Photos, via VBA

Asked

Viewed 132 times

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.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.