Hi,
I wonder if anyone can help?
I am trying to figure out how to insert the newest JPG file from a given folder into a certain location in a spreadsheet.
The pictures are images captured from a camera which are inserted as JPG files into the same folder each time.
I need to be able to insert the most recent file into the spreadsheet.
Any help would be appreciated
123rich456,
Welcome to the forum!
Give the below code a try. When you run it, you'll be asked to select the folder containing the JPG files. After that, you'll be asked to select the cell that the picture will be placed in. This is the cell that will have the top-left corner of the image.
Please Login or Register to view this content.
How to use a macro:
- Make a copy of the workbook the macro will be run on
- Always run new code on a workbook copy, just in case the code doesn't run smoothly
- This is especially true of any code that deletes anything
- In the copied workbook, press ALT+F11 to open the Visual Basic Editor
- Insert | Module
- Copy the provided code and paste into the module
- Close the Visual Basic Editor
- In Excel, press ALT+F8 to bring up the list of available macros to run
- Double-click the desired macro (I named this one Insert_Newest_JPG)
Last edited by tigeravatar; 06-18-2012 at 02:25 PM.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Alter path to Suit
Code places the latest JPG on sheet.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks