Another FileSearch Question Please Read

[WhistleHEad]

Hello Group,

I understand that FileSearch has been dumped from the Excel Repository,
however by unhiding hidden object in Office 2007 Excel I find that it is
available as a Hidden "Office" Object. This was released in the Office
SvcPk2.

Is there anyway to refer to this object in Excel, I can not see the
purpose of having an object (hidden or not) in a suite of programs if it
can not be referenced.

FileSearch is a major workhorse and worked quite well in most of my
spreadsheets that have to find the last excel sheet posted in a folder
(or in older terms, a directory) in order to gather information or
template information from the workbook.

Documentation in Excel(2007) points to code that uses input or list boxes
to find files but I need this automated.

Any direction would be appreciated, (I am really hope that the hidden
object can be used and referenced simply with a replace statement from
"with App.FileSearch" and change the reference to "with
"(newHiddenObject).FileSearch" so that I do not have to rewrite the code
in some 50 or 60 spreadsheets.)

Anyway, thanks in adavance.

WHistleHead

 

[Patrick Molloy]

use a class module to replicate the FileSearch method. all you need to do
then is drag/drop it from a folder (or desktop) in to your excel workbooks
I agree its not ideal, but the code changes thereafter should be minimal IF
the object has all the methods of the original.

I'm building a demo that I'll post later..maybe tomorrow

 

[WhistleHEad]

Thanks Patrick,

I look forward to your demo. I'm always into learning something new.

WHistleHead