Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Findfiles finds(?) phantom files....
I have a handful of macros that I have bundled into an addin for
distribution to my colleagues. Despite all efforts to be clear on how/where to install it, some users continue to have trouble. The result of this is that when I send an update, some people are having trouble as they have copies in multiple locations.... In an effort to overcome this I have a wrote another macro that uninstalls the addin, then finds and deletes the source file(s). This works fine except that the .findfile part appears to be finding files on the H: drive (a network drive) that don't (as far as I can tell) exist (actually, the really perplexing part is that it appears to find multiple instances of the SAME file in the SAME directory, eg test.xla and Test.xla...) code is as follows (the KILL statement has been replaced with the messagebox so I could see what was returned) - With Application.FileSearch .NewSearch .LookIn = "h:\" .SearchSubFolders = True .Filename = "test*.xla" .MatchTextExactly = True If .Execute 0 Then For i = 1 To .FoundFiles.count ' Kill .FoundFiles(i) StrMsg = StrMsg & .FoundFiles(i) & vbCrLf Next i End If MsgBox StrMsg End With I've asked around and noone I know has ever seen anything like this and I'd really like to solve it (I'm keen to get rid of all those old versions...) so all suggestions gratefully received TIA S -- Instead of building bigger and better weapons of mass destruction, we should be trying to get better use out of the ones we've already got.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Phantom Links | Excel Discussion (Misc queries) | |||
Phantom links | Excel Discussion (Misc queries) | |||
phantom headers | Excel Discussion (Misc queries) | |||
phantom headers | Excel Worksheet Functions | |||
Phantom Links | Excel Programming |