Run time error 445 FileSearch false horse tails

Experiment such that you can solve the second question yourself.

-- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

== English articles == Excel memes

VB: Macro5() Sheets(RCENUM).Select i Application.FileSearch .NewSearch .LookIn = C:\Program files\Horse Racing Fantasy\Races\rcefiles .SearchSubFolders = .Filename = . .Execute 0 i = 1 .FoundFiles.Count Cells(i, 5).Value = .FoundFiles(i) i

== English articles == Excel memes

VB: fs, FilePath , i , wbSource Workbook FilePath = C:\Program Files\Horse Racing Fantasy\Races\rcefiles fs = Application.FileSearch fs .NewSearch .LookIn = FilePath .SearchSubFolders = .FileType = msoFileTypeAllFiles .Execute i = 1 .FoundFiles.Count wbSource = Workbooks.Open(.FoundFiles(i), ) 0 wbSource MsgBox Unable to open the file > Workbooks.Open(myDir &nglish articles == Excel memes

So, am I just replacing the code that I posted with the code that you posted? I really have no idea about this stuff.yes, and experiment with the code. Make copies of the file(s) so as not to loose anything important.

FileSearch() was removed in 2007 so yesHorse hair fabric-No.63-Herdsma, you need another method. For just a parent folder, the Dir() method will suffice. Otherwise, one can use an fso method if iterating the parent and subfolders if needed.

I also found another instance of FileSearch as I looked through the macro. Would I use your posted code to replace this as well?

-- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. If you dont like Google AdSense in the posts,Horse hair fabric-No.59-Herdsma, register or log in above.

-- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

So, am I just replacing the code that I posted with the code that you posted? I really have no idea about this stuff.

OK, I just got Office 2007 put on my computer and had no idea that a macro that Ive been using for quite a long time would stop working. From researching some, I know what the problem is. FileSearch is no longer valid. Ive seen some of the things to correct it, but I cant make heads nor tails of it. I was given the spreadsheet by the person who developed it (and no longer is part of our game), but I have no idea how to write the code. If anyone could point me in the right directionHorse hair fabric-No.43-Herdsma, it would be greatly appreciated. Thanks in advance.