Re: Help with FileSearch in Word 2007 VBA "New Text Document.txt" (1/1) yEnc 466 Bytes

[Evan Riskedahl]

The Application.Filesearch was removed in the 2007 vba you need to create an array of each item in the directory you're looking in.

> On Thursday, September 02, 2010 12:33 PM jimoc wrote:

> I "upgraded" to Office 2007 and am trying to get my VBA code to run.
>
> In one of the forms, a FileSearch is used to populate a ListBox with templates.
>
> It worked fine with Word 2003
> I have essentally the same references (just changed 2 from microsoft word and office 11.0 object library to 12.0)
>
> Now when I run the code, it errors and indicated that the Application.Filesearch
>
> " Application.Filesearch = < this command is not available on this platform.> "
>
>
>
> here is how the code starts
>
> With Application.Filesearch
> Lookin = ""
> searchsubfolders = false
> Filename = "*.dot"
>
> and so on
>
>
> Is there something else I need to reference that is not mentioned in the (poor) help files
>
> I appreciate any help.
> Jim
>
>
> =ybegin size=466 line=128 name=New Text Document.txt
> =ypart begin=1 end=0
> ????Jk??????????Xp???}?????74JJJJXv???s?JgJ~???????z???74JJJJX}?????}??p??????JgJp????74JJJJXp???x???JgJLTX???L74JJJJXp???~???Jg
> J???p???~???k??p????74JJJJs?JXo??????RSJhJZJ~???74JJJJJJJJp??J?JgJ[J~?JXp????p????Xm????74JJJJJJJJJJJJ~???x???JgJ|????RXp????p??
> ??R?SVJRv??RXp????p????R?SSJWJs?}??|??RXp????p????R?SVJL?LVJW[SSS74JJJJJJJJJJJJ~???????v???l??Xk??s???J~???x???VJ?JWJ[74JJJJJJJJ
> JJJJ~???????v???l??Xm?????R[VJ?JWJ[SJgJXp????p????R?S74JJJJJJJJx???J?74JJJJo???74J
> =yend size=466 crc32=DA64C479

> Submitted via EggHeadCafe
> JSONP AJAX and ASP.NET Demystified
> http://www.eggheadcafe.com/tutorials/aspnet/b71ea548-93e0-4cec-9fb1-35f641b83e65/jsonp-ajax-and-aspnet-demystified.aspx