LinkBack URL
About LinkBacks
Below is the code I currently have that opens all the files that end in .xls in the path. However this does not seem to work in excel 2007. Any suggestions on how to change this to work on 2007?
Please Login or Register to view this content.
Below is the code I currently have that opens all the files that end in .xls in the path. However this does not seem to work in excel 2007. Any suggestions on how to change this to work on 2007?
Please Login or Register to view this content.
Last edited by randell.graybill; 08-13-2010 at 12:32 AM.
randell.graybill,
See:
By Peter_SSs
http://www.mrexcel.com/forum/showthr...ht=fList%28%29
By RichardSchollar
http://www.ozgrid.com/forum/showpost...73&postcount=4
Application.filesearch was dropped in xl2007.
http://www.thecodecage.com/forumz/ex...directory.html
John Walkenbach has some code here:
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Thanks for the effort however those use the same method I already have posted.
I was able to find the answer I was looking for:
Source = http://www.excel-it.com/Excel%202007...filesearch.htm
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks