Insert Picture from Folder in Microsoft Excel | Pick up Pictures form Folder
HTML-код
- Опубликовано: 15 окт 2024
- This tutorial will show you how to pick up Photographs from a particular Folder in the computer in Microsoft Excel. I used vlookup formula to automatically import the students’ information to the analysis sheet. We can use this method to create Employees information and manipulating large data to find out particular information for particular entity. Follow the following steps to design such excel workbook.
Step1: Prepare students passport size photographs and store them in a folder.
Step2: Re-name the photographs to students Roll Number or Scholar Number.
Step3: Create an excel workbook and save it as Macro-Enable Worksheet
Step4: Rename the first sheet1 to Information and sheet2 to Analysis.
Step5: Enter students details i.e. Name, Class, Roll no., Address, Contacts etc.to the ‘Information’ sheet.
Step 6: Decorate the ‘Analysis’ sheet using colours, shapes to make it attractive.
Step7: Use vlookup to automatically import information form ‘Information’ sheet.
Step7: Use Developer Tab and insert two Image Control
Press ‘Ctrl+F11’ to open VBA window and type the code to pickup photographs.
Sir indeed very useful vedio. Kindly describe the full vba code. It will be a great help. Thanks n regards.
Pls paste photo pick up code in description
Can we get the excell file?
can we get the file excel and macro sir? thanks
If you recieve it, may I get a copy as well?
Is this available in the English language?
where to download the code
kindly update us on the code.information even if it means at a cost please
Plz the code sir
Not Useful,
You are very stingy in your explanation, shame on you.
Sir indeed very useful vedio. Kindly describe the full vba code. It will be a great help. Thanks n regards.