PDA

View Full Version : excel - search for document and open



kirstybear
03-31-2018, 05:59 AM
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.

SamT
03-31-2018, 08:30 AM
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.

kirstybear
03-31-2018, 08:45 AM
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.