I volunteer at a Habitat for Humanity store. They use excel to produce a description / price paper which is attached to the item. We would like to add a photo to that paper. I know how to do it manually, but we create up to 100 of these papers at a time. So, doing it manually would be way too slow.
Does anyone here know how I could take a photo and somehow it auto populates a a spot on an excel spreadsheet?
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Hi,
We produce a single sheet at a time. See attached. It is a simple excel spreadsheet. We just want to add a photo of the item as shown in the attachment.
We do as many as 100 when we do these. Dragging and dropping a photo in is just too slow.
Ideally, I would like to take a photo, wirelessly upload a photo to a folder somewhere and have it automatically populate the photo box.
This would be printed out and attached to the item.
To get started we can use code to insert a picture into your range of cells.
Test this out, change the picture file in the code to one of your picture files
Please Login or Register to view this content.
Once you have that working, we will need to find a way to get the picture file name to be inserted into that range of cells.
Hi SJMaye,
Try Excel File ExcelForumPriceTagPictureImporter.xlsm in the attached .zip file which contains:
a. ExcelForumPriceTagPictureImporter.xlsm - Excel file that imports pictures into your files
b. ExcelForumPriceTagResultFile.xlsm - A copy of your file (for the convenience of others who want to try the software)
c. ExcelForumPriceTagImage022.jpg - Sample Picture file
d. ExcelForumPriceTagImage022.png - Sample Picture file
e. ExcelForumPriceTagImage024.png - Sample Picture file
Instructions for use:
a. Put this file (ExcelForumPriceTagPictureImporter.xlsm )in the same folder as your pictures.
b. 'Left Click' the 'Import …' Yellow Shape on 'Sheet1' to put pictures and file names on 'Sheet2' in this file.
c. Open one Destination File.
d. Go to 'Sheet2' in this file. 'Double Click' a File Name to put the Picture and the File Name in the Destination File.
e. Save and close the Destination file.
f. Repeat c. thru e. as required.
g. To UNDO a strikthrough on 'Sheet2' Column 'B', 'Double Click' Column 'F' in the required row.
Complete Code follows (all code is in file ExcelForumPriceTagPictureImporter.xlsm). Items in red can be changed as required.
In the 'Sheet2' code module:
In Ordinary Code Module x:Please Login or Register to view this content.
LewisPlease Login or Register to view this content.
ExcelForum would not allow me to Edit previous post to attach file. Attached file is in this post.
Lewis
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks