Hi all, I'm a beginner and need help.
I'm trying to get VBA to search for a stipulated workbook in another drive, that name is entered into a textbox then hit search button.
If the workbook exists, then it opens it, if it doesn't, a message to say not found.
I just can't seem to get anything to work.
I'm trying to get VBA to search for a stipulated workbook in another drive, that name is entered into a textbox then hit search button.
If the workbook exists, then it opens it, if it doesn't, a message to say not found.
I just can't seem to get anything to work.