T
The Wonder Thing
Hello Everyone!
I've got an interesting question. I'm wondering if it's possible to write a macro that can search through a particular directory (and sub-directory) and match a filename and address path to the contents of a cell. That's all I need to know, after that I know how to make the cell link to the file, but I have no idea if the file-searching is even possible with Excel VBA.
It's just getting really annoying browsing for each file seperatly every time I want to link (I have a lot of entires to link to thier drawing files). If there's any other way to speed this up, please tell me about that too.
Thanks!
I've got an interesting question. I'm wondering if it's possible to write a macro that can search through a particular directory (and sub-directory) and match a filename and address path to the contents of a cell. That's all I need to know, after that I know how to make the cell link to the file, but I have no idea if the file-searching is even possible with Excel VBA.
It's just getting really annoying browsing for each file seperatly every time I want to link (I have a lot of entires to link to thier drawing files). If there's any other way to speed this up, please tell me about that too.
Thanks!