application.filesearch

[dstiefe]

would anyone know why the

application.filesearch

would not work on my system

in otherwords when I am typing "application." the "filesearch" method does
not even pop up as an option..

 

[Ron de Bruin]

Hi dstiefe

It is removed in 2007 because there where a few bugs in it
You can use Dir or FSO if you want

See
http://www.rondebruin.nl/copy3.htm

Or
http://www.rondebruin.nl/fso.htm

For example code

 

[dstiefe]

how would you open all of the xls files in a folder?

 

[Ron de Bruin]

Hi dstiefe

Look at the code on the example pages and read the comments in the code

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm