Hello there,
I want to set a number of hyperlinks in an excel sheet that will point to the files referred by shortcuts that are stored in a certain folder.
when I manually use filesearch the shortcuts appear, but through vba, no matter what I do filesearch.foundfiles.count is always 0 if only shortcuts are present in the folder (I tried putting a real file and it does find it)
is there anything that can be done about it?
If that were possible, I guess that making a hyperlink to a shortcut will also open the file, right?
that would allow me to avoid a huge number of file duplication...
please help!
Bookmarks