missing Application.FileSearch excel 2007
in [Programming]
|
From: John on 13 May 2010 19:13 What do you use instead of the missing Application.FileSearch? Thanks John
From: Dave Peterson on 13 May 2010 20:53 Ron de Bruin shares some alternatives here: http://www.rondebruin.nl/fso.htm and http://www.rondebruin.nl/copy3.htm On 05/13/2010 18:13, John wrote: > What do you use instead of the missing Application.FileSearch? > Thanks > John
From: broro183 on 13 May 2010 20:56 Hi John, Have a look at RoyUK's example: 'Excel 2007 Filesearch' (http://excel-it.com/Excel%202007/2007_filesearch.htm) hth Rob -- broro183 Rob Brockett. Always learning & the best way to learn is to experience... ------------------------------------------------------------------------ broro183's Profile: http://www.thecodecage.com/forumz/member.php?u=333 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=202700 http://www.thecodecage.com/forumz
From: JLatham on 13 May 2010 21:13 There are several approaches to this in this discussion: http://social.msdn.microsoft.com/Forums/en/isvvba/thread/a450830d-4fc3-4f4e-aee2-03f7994369d6 I lean toward the use of the file system object (FSO) generally, although jpschmit puts up a nice solution. Search for jpschmit on the page to find his post quickly. "John" wrote: > What do you use instead of the missing Application.FileSearch? > Thanks > John > . >
From: John on 13 May 2010 21:42 thanks. I made do using dir. Had forgotten about that. JOhn Dave Peterson wrote: > Ron de Bruin shares some alternatives here: > > http://www.rondebruin.nl/fso.htm > and > http://www.rondebruin.nl/copy3.htm > > On 05/13/2010 18:13, John wrote: >> What do you use instead of the missing Application.FileSearch? >> Thanks >> John
|
Pages: 1 Prev: Negative to zero code Next: selection.copy = "picture too large" |