Function Browse Folder Select but I have to Reload twice in subs What am I missing here

Hi All,
I am still a bit green in how all this hangs together.
I want to bet able to use the Value from Function ChooseFolder() once Folder is selected
to only load once and carry Folder Value through all my subs.I think my call sub structure may not be 100% correct
a fresh set of experienced eyes would be appreciated


the code below works in blank wookbook for testing if needed



thanks
regards Peter

Please Login or Register  to view this content.

Pass the folder name as a parameter to Sub 2

Please Login or Register  to view this content.