Excel VBA Macro for Image Tool

Job ID: 37683648

Budget: ₹1,500 – ₹12,500 INR

I'm seeking an experienced VBA coder for building a macro code in Excel. The primary purpose of the code will be the creation of an Image Paste tool. Significant experience in VBA and familiarity with Excel are both vital attributes. Any previous work involving Image tools using VBA would be advantageous to this project.


Scenario is, we have input folder(eg. 1,2,3,4,5,6) for images that folder contains multiple subfolders(eg. For folder name 1 we have subfolders 1-01,1-02,1-03....,for folder name 2 we have 2-01,2-02.... Like that and so on for other folders also), so we have to paste this images in the worksheets which will be created according to folders (e.g. inside the workbook worksheets should be named like "name of input folder-name of subfolder" like 1-1-01, 1-1-02, 1-1-03, and so on for other folders)contained in the output folder (eg. Folder names are 1,2,3,4,5,6) .
Images are laptop screen size, that should pasted in manner that one below another by 2 rows space in between, and images should be place over the cells .

Scenario is, we have input folder(eg. 1,2,3,4,5,6) for images that folder contains multiple subfolders(eg. For folder name 1 we have subfolders 1-01,1-02,1-03....,for folder name 2 we have 2-01,2-02.... Like that and so on for other folders also), so we have to create the workbooks in specified output folders, take specified output folders name from user . In those workbooks we have to create worksheets based on the user value.
Before adding the sheets the workbook must be empty even default Sheet1 also be deleted