W
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
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