Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ms excel 2007 Filesearch
I have the following code developed in Excel 2002. I have noted from
this group that .Filesearch is not longer supported in ms excel 2007. I would like for this code to search for text "budget" in all workbooks and return the file and it's path to either a listbox or compile a list of all of the files names and path into an Excel Workbook. I am kind of lost on reworking this code with VBA in MS Excel 2007. Any suggestions you have would be greatly appreciated Sub findfiles() With Application.FileSearch .NewSearch .LookIn = "C:\" .SearchSubFolders = True .TextOrProperty = "Budget" .MatchTextExactly = False .Filename = "*.xls" .Execute For i = 1 To .FoundFiles.Count UserForm1.ListBox1.AddItem.FoundFiles (i) Next i End With UserForm1.Show End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ms excel 2007 Filesearch
From a February 8th post:
Newsgroups: microsoft.public.excel.programming From: "Ron de Bruin" Date: Fri, 8 Feb 2008 19:11:31 +0100 Local: Fri, Feb 8 2008 11:11 am Subject: Filesearch error in Excel 2007 Hi Libby It is removed from 2007 You can use Dir or FSO See the merge code on my site, you can use that for your macro http://www.rondebruin.nl/copy3.htm |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ms excel 2007 Filesearch
On May 8, 9:55*am, dan dungan wrote:
From a February 8th post: Newsgroups: microsoft.public.excel.programming From: "Ron de Bruin" Date: Fri, 8 Feb 2008 19:11:31 +0100 Local: Fri, Feb 8 2008 11:11 am Subject: Filesearch error in Excel 2007 Hi Libby It is removed from 2007 You can use Dir or FSO See the merge code on my site, you can use that for your macrohttp://www.rondebruin.nl/copy3.htm Thanks I will take a look at your page. I appreciate your help. D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FileSearch Excel 2007 | Excel Discussion (Misc queries) | |||
application.filesearch error in excel 2007 | Excel Programming | |||
Filesearch error in Excel 2007 | Excel Programming | |||
Excel 2007 filesearch | Excel Programming | |||
replacement for filesearch in excel 2007 | Excel Programming |