FileSearch fails to find shortcuts!

**bagullo** · 07-06-2011, 08:40 AM

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!

**bagullo** · 07-07-2011, 03:45 AM

Oh well, I might give up and think some other way around with actual files and not shortcuts!

**romperstomper** · 07-07-2011, 03:47 AM

Since Filesearch won't work from 2007 onwards, I suggest you abandon it now and use Dir or the Scripting.FileSystemObject instead.

**bagullo** · 07-07-2011, 04:25 AM

Originally Posted by romperstomper

Since Filesearch won't work from 2007 onwards, I suggest you abandon it now and use Dir or the Scripting.FileSystemObject instead.

Wow, didn't know that!

Thanks a lot, I'll try to switch before it's too late

**snb** · 07-07-2011, 04:27 AM

A schortcut has a hidden .lnk extension:

The shortcut to "E:\files.xls" is "E:\files.xls.lnk"

**bagullo** · 07-07-2011, 09:39 AM

Originally Posted by snb

A schortcut has a hidden .lnk extension:

The shortcut to "E:\files.xls" is "E:\files.xls.lnk"

Do you mention that for the Dir instruction?

I tried that already in filesearch (even without any filtering at all) and would just tell me that there were 0 files found in that folder....

We actually changed our working structure so I do not have to link to shortcuts anymore