I have been tasked with creating measurable metrics based on entries made into our daily log, based on a nightly audit. Management has requested a screen shot of any error found prior to a correction. Since there are several employees that perform this nightly audit, I have created a simple input form for each entry, that when saved populates a separate worksheet. But, I am stuck with the images. What I envision at the moment is: The auditor will capture the appropriate info, using the snipping tool, and save it to a folder C:\Images and give it a unique name, 12345. He would then enter that name into the input form, cell "A1". When the entry is saved I want to save that file name into cell "J1" as a link to the original file C:\Images\12345.jpg. Sorry, if this is a little long winded, but I am brand new to the world of VBA.
Thanks in advance for any ideas, or suggestion that might send me down a new rabbit hole.
Jim
Thanks in advance for any ideas, or suggestion that might send me down a new rabbit hole.
Jim