Search SubDirectory VBA

[jamesdpmullan]

Hi,

Im 2 years into my database however this is really getting to me!

Im trying to find and open a folder based on a text box. The problem is folder could be in many sub folders which is hold on our J:\ drive.

To further complicate, the folder i am searching may not be exactly as the text box states.

EG. Text box could say 123456 however the folder could be called M123456 etc.

How do i locate a folder or subfolder and open it based on part of a text box

Many thanks for your help!

 

[pr2-eugin]

You might need to modify (quiet a lot). But is a good place to start.

http://allenbrowne.com/ser-59.html

 

[vbaInet]

Perhaps you should sort out your data. There could be more than 1 folder matching "123456". What do you do in that case?

 

[gemma-the-husky]

you need to store the full path to the file (or a relative path based on the location of the active database)