tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
So I need i macro to do the following
when run open the file explorer window,
Goto the folder in activesheet D12,
and show me all XLSX docs.
ask me to choose file to open
If i choose a file it opens that document and saves the name of the document in activesheet D20
if its closed without choosing or cancel is pressed I get a message saying No Document chosen.
please help if yoiu can
Thanks
Tony
So I need i macro to do the following
when run open the file explorer window,
Goto the folder in activesheet D12,
and show me all XLSX docs.
ask me to choose file to open
If i choose a file it opens that document and saves the name of the document in activesheet D20
if its closed without choosing or cancel is pressed I get a message saying No Document chosen.
please help if yoiu can
Thanks
Tony