-
Need Help With Input Box To Open File in Specified Path
Greetings experts,
I am trying to create an input box which will request for a file path to put into a code before running the code. Attached here is an example file:
https://filedb.experts-exchange.com/incoming/2019/04_w14/1416803/example.xlsm
Right now, I have created an example file with a button. When this button is pressed, the inputbox should appear.
1.JPG
After the user presses ok, the file path should be put in between the single apostrophes of this code:
2.JPG
If they didn't input anything, they should prompted to re-enter.
After that, the form should appear. For subsequent uses, if there is already a file path saved, a different inputbox should appear asking if the saved file path is the correct file path which will also be able to change the file path if needed.
Any help is much appreciated
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules