tag:blogger.com,1999:blog-28492262.post6026423732497986264..comments2023-12-27T22:22:25.151-08:00Comments on VBA Tips & Tricks: Search and Open Files using Excel VBA (FileSearch)Unknownnoreply@blogger.comBlogger11125tag:blogger.com,1999:blog-28492262.post-29097950839541091192012-03-29T09:51:17.802-07:002012-03-29T09:51:17.802-07:00Why don't all you people make an effort to fig...Why don't all you people make an effort to figure these questions yourself. Just because he posted some useful info doesn't make him your lackey. Bunca lazy azzesAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-13720893659674738382011-12-15T08:22:23.626-08:002011-12-15T08:22:23.626-08:00I need to sort thousands of excel files into folde...I need to sort thousands of excel files into folders based on a name found in the same tab and cell within each file. These need to be moved into a folder with a matching name to the string contents of that cell. Is there a way in vba to do this sorting process for me?srrichardson1111https://www.blogger.com/profile/11416450355561329544noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-5974737271906092722011-11-30T00:32:27.765-08:002011-11-30T00:32:27.765-08:00can you modify the script to search word or string...can you modify the script to search word or string inside a files present in the foldershameemhttps://www.blogger.com/profile/08100931776225035735noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-35632851095550375122011-07-22T04:24:59.864-07:002011-07-22T04:24:59.864-07:00can we search all empty folders and filescan we search all empty folders and filesAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-18157856946490268622011-03-06T23:33:21.707-08:002011-03-06T23:33:21.707-08:00Can you modify this VBA to search in more then one...Can you modify this VBA to search in more then one folder. Let's say I'll give him the path of the folder to search in, but there he will meet more folders to be searched.Horbaniuc Vladhttps://www.blogger.com/profile/03822384132492448693noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-81695566944611361962011-03-06T23:31:57.836-08:002011-03-06T23:31:57.836-08:00Hi, can excel look in more then one folder ?
Let&#...Hi, can excel look in more then one folder ?<br />Let's say I give him a folder were to search, and then there are more folders to search in for the specified file.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-22318651685965290332011-02-15T10:02:09.859-08:002011-02-15T10:02:09.859-08:00I need help!! I have tons of excel worksheets in a...I need help!! I have tons of excel worksheets in a folder but I want to search and find them quicker and have them automatically open.Unknownhttps://www.blogger.com/profile/16138666916024923275noreply@blogger.comtag:blogger.com,1999:blog-28492262.post-19474125397192875322011-01-04T06:44:05.416-08:002011-01-04T06:44:05.416-08:00If filesearch a property or object or both?If filesearch a property or object or both?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-84662609316130285462010-10-26T01:05:04.679-07:002010-10-26T01:05:04.679-07:00Hi there...Can you post a code that can filter a d...Hi there...Can you post a code that can filter a data in table and returns its value in a notepad.Is it possible?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-90855003303385833712009-02-26T18:24:00.000-08:002009-02-26T18:24:00.000-08:00Application.FileSearch will throw error if you are...Application.FileSearch will throw error if you are using Office 2007. You can use the following workaround :<BR/><BR/>http://www.ozgrid.com/forum/showthread.php?t=71409Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-28492262.post-81255351048005661342009-02-26T17:48:00.000-08:002009-02-26T17:48:00.000-08:00The application.filesearch keeps returning an erro...The application.filesearch keeps returning an error. How do I make this work?Anonymousnoreply@blogger.com