Posted to microsoft.public.excel.programming

external usenet poster

Posts: 8

Application.FileSearch Problems

Hi-

I just upgraded to Office '07 and I am having trouble with some code.
The following code works in 97 but does not work in 2007.

With Application.FileSearch
.NewSearch
.LookIn = "N:\Sales\MAP ROLLUP"
.SearchSubFolders = False
.Filename = "*.xls"
.Execute

Does anyone know how to code the above in 2007?

Thank You!

Chris

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Set fs = Application.FileSearch	[email protected]	Excel Programming	4	April 15th 08 10:17 PM
Application.FileSearch Help	Patrick Kirk	Excel Programming	2	April 7th 08 06:22 PM
Problems with Application.FileSearch	Jim Rech	Excel Programming	0	December 15th 06 05:18 PM
What is better: Application.FileSearch or Dir ??	WhytheQ	Excel Programming	9	October 25th 06 01:29 PM
Application.Filesearch	EA	Excel Programming	3	August 17th 06 10:07 AM

All times are GMT +1. The time now is 08:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us