FolderPath_Password in given cells instead of vba script/code

Dear Excel Gurus,
I have a file of summary, which is obtaining desired information from different workbooks and its worksheets, the existing macro is working well, however, due some limitation, I would like to move “Folder path” and “Password” from vba script/code to summary sheet’s specific cells i.e.

Folder path in Worksheet named FolderPath_Password in cell B1

&

Password in Worksheet named FolderPath_Password in cell B3

The vba script/code is as follows;

Please Login or Register  to view this content.

Please help to resolve the mentioned queries.

File is attached for reference
Thanks in an advance for your as usual support and contribution.

Ravindrak

Please Login or Register  to view this content.

Thanks for your response.
However, it is not working with adding /modifying above code.

it stuck's at

Please Login or Register  to view this content.

Thanks in an advance.

Ravindrak

Please help to resolve the mentioned queries.

Thanks in an advance for your as usual support and contribution.

Ravindrak

Can anyone please help me to resolve my query.
Thanks in advance.
Ravindrak

Can anyone please help me to resolve my query.
Thanks in advance.
Ravindrak

Anybody know this.
Please help me.

Thanks in advance.

RavindraK

Can anyone please help me to resolve my query.
Thanks in advance.
Ravindrak

Anybody know this.
Please help me.

Thanks in advance.

RavindraK

Thanks a lot boss, you are really charm !!
It's resolved now.
RavindraK