How to put File destination in Excel cell

[rajeshn_in]

Hi friends,

I am suing below VBA to open, save and close other files. I want to put File destination ("C:\Dropbox\RGPLSG 6\Exports - Sales - 1 - 2017\Exports - Sales - 1 - Helper - 2017.xlsm") in Excel cells like in Sheet1!A1, So that easyly I can change destination when every I want.
Please make changes in below vba.

Please Login or Register  to view this content.

Thank you

[YasserKhalil]

Hello
Give this a try

Please Login or Register  to view this content.

[rajeshn_in]

Its working,

Thank you verymuch YasserKhalil

[YasserKhalil]

You're welcome
Glad I can offer some help
Please mark the thread as solved

Regards