Hello, could you please help me with this.
I have a Userform with Combobox. What i need is when i pick months in Combobox and hit the button "GO", it will check if the file is available else it will display "Not yet available". When it's available, the file will be open.
Example path: C:\NEW ADHOCS\January.xlsx, C:\NEW ADHOCS\February.xlsx (this is only available, other months is not)
When I choose January, it will open January.xlsx
When I choose February, it will open February.xlsx
When I choose March or other months, message will pop-up "Not yet Available".
I have attached the sample file. Thanks in advance.
Bookmarks