| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filesearch error in Excel 2007
Answered he
http://groups.google.com/group/micro...03da44cc?hl=en On Feb 8, 1:46 pm, Libby wrote: Thanks again. Another thing not supported by the new Excel. So far I'm struggling to see any advantages. "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Libby" wrote in ... Hi I have a sub that add files in a folder to a listbox. It worked fine in Excel 2003, but now in Excel 2007 it doesn't and I get an error. the code is below Sub Fill_Listbox strDir = path of folder ChrDir strDir With Application.Filesearch .NewSearch .LookIn = strDir .SearchSubFolders = False .FileType = msoFileTypeAllFiles If .Excecute() 0 Then For i = 1 to .FoundFiles.Count 'Add file name to listbox Next i end if End with I've stepped though and the error occurs at the With Application.FileSearch part. The error is Run-time error 445. Object doesn't support this action. Can anyone tell my why this doesn't work in Excel 2007 and if possible how to achieve the same results using Excel 2007? Many thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FileSearch Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2002 to 2007 Macro containing "Filesearch" | Setting up and Configuration of Excel | |||
| Excel 2007 filesearch | Excel Programming | |||
| Application.FileSearch in 2007 | Excel Programming | |||
| replacement for filesearch in excel 2007 | Excel Programming | |||
Hybrid Mode
