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

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" wrote in message
...
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

Thanks Patrick,

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

WHistleHead

"Patrick Molloy" wrote in
:

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" wrote in message
...
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