Prev: Calculate age
Next: Randomizing
From: shaz on 19 Mar 2010 20:49
Hello, is there a File Search command in Excel 2007 please?
From: Dave Peterson on 20 Mar 2010 07:42
Application.filesearch was removed with xl2007.

Ron de Bruin shares some alternatives here:

http://www.rondebruin.nl/fso.htm
and
http://www.rondebruin.nl/copy3.htm

shaz wrote:
>
> Hello, is there a File Search command in Excel 2007 please?

--

Dave Peterson
From: מיכאל (מיקי) אבידן on 20 Mar 2010 09:42
You may also consider the work-around using the FileSystemObject object.
http://support.microsoft.com/kb/185601
Micky


"shaz" wrote:

> Hello, is there a File Search command in Excel 2007 please?
From: shaz on 20 Mar 2010 19:38


"Dave Peterson" wrote:

> Application.filesearch was removed with xl2007.
>
> Ron de Bruin shares some alternatives here:
>
> http://www.rondebruin.nl/fso.htm
> and
> http://www.rondebruin.nl/copy3.htm
>
> shaz wrote:
> >
> > Hello, is there a File Search command in Excel 2007 please?
>
> --
>
> Dave Peterson
> .
> But how does a user not wanting to use programming language search for a file in 2007?
From: Dave Peterson on 20 Mar 2010 22:07
I've always searched for files using windows search (ctrl-f in windows
explorer).

shaz wrote:
>
> "Dave Peterson" wrote:
>
> > Application.filesearch was removed with xl2007.
> >
> > Ron de Bruin shares some alternatives here:
> >
> > http://www.rondebruin.nl/fso.htm
> > and
> > http://www.rondebruin.nl/copy3.htm
> >
> > shaz wrote:
> > >
> > > Hello, is there a File Search command in Excel 2007 please?
> >
> > --
> >
> > Dave Peterson
> > .
> > But how does a user not wanting to use programming language search for a file in 2007?

--

Dave Peterson
 | 
Pages: 1
Prev: Calculate age
Next: Randomizing