new folder creation and moving of photos into that created folder on different drive

Hello friends, I have two queries,
Issues:
1. issue explanation- Pls check the attachment file "folder creation and fotos copied into the newly created folder at the specified folder,.. "
2. issue explanation: Pls refer the spreadsheet file "search & open that created folder from spreadsheet cell value linked thru hyperlink"

Issue Summary: when click it need to make a new folder on different location (d:\db) and then copying of photos into that created folder from photos source location (c:\fotos folder) to the destination of newly created folder (d:\db) from the cell value (eg: C4 as 9224) of spreadsheet. and also, i'm looking for the coding of cell value linked to that newly created folder as a hyperlink to open whenever we want to check the folder files...

Pls check the attachment files for issue clarity... Thanks in advance for your time and effort for reading...

I think this is the extreme usage of excel, but I hope from our excel gurus to solve this type of scenario…

Any help will be highly appreciated in this regard….

Please Login or Register  to view this content.