Hello All,
Here is the situation and I'm not sure if this is possible. I'm working on a macro connected to a command button. Now when a sure clicks on the button. One of those Windows directory windows appears and prompts the user to select a folder. The folder path is then extracted and separated outs. The folder path will typically be in this format.
J:\Projects\### Text\###-##-## Text\Doc
I need the information located in "\### Text" and "\###-##-## Text".
Anyways if this is possible please let me know. I'll continue to do research to see if this is possible.