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" <(E-Mail Removed)> wrote in message
news:Xns9C4B4AEBC43B1WhistleHEad@69.16.185.250...
> 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" <(E-Mail Removed)> wrote in
news:E037E7FB-4263-4990-8FF5-(E-Mail Removed):

> 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" <(E-Mail Removed)> wrote in message
> news:Xns9C4B4AEBC43B1WhistleHEad@69.16.185.250...
>> 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
>
>