excel - search for document and open
I am trying to create a search bar in excel that links to folder with various letter templates in it, im a trying to link that folder to the search bar so they can just type the file name for example returns letter and it will find it and open it for them
A bit like searching this forum to find a specific thread.
Is this possible?
I am new to VBA and have been trying to use the Getopenfilename but can't seem to get it to work for me or know where to begin.
Why not use an Excel built-in Dialog? Specify the folder path, then the user just has to click the file name to open it.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Because there are around 30 of them that the user will need to use at any one time and they are in different folders.
This would be on a workbook that has other features such as a dash board so was trying to keep everything together.
They are all word docs the user would have tonopen so they can use.
Posting Permissions
Reply With Quote
