Another FileSearch Question Please Read

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
 
P

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
 
W

WhistleHEad

Thanks Patrick,

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

WHistleHead
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top