Replacement for Application.FileSearch in Word2007/10

[markus.pflugrad]

Hi together,

I am not well experienced in vba/makros etc in the msn Office products.
We are using a old word 2003 .dot which includes the code for a few smalleroperations. The main problem now in 2007 is, that we are not able to open the picture folder to mark there the pictures which should be automaticallyget ordered and imported to the created word.doc.

Would be great if someone could help me out - telling me, how to fix that old piece of code.

regards, Markus

 

[Michael Bednarek]

I am not well experienced in vba/makros etc in the msn Office products.
We are using a old word 2003 .dot which includes the code for a few smaller operations. The main problem now in 2007 is, that we are not able to open the picture folder to mark there the pictures which should be automatically get ordered and imported to the created word.doc.

Would be great if someone could help me out - telling me, how to fix that old piece of code.

There are plenty of code snippets out there to work around the lack of
Application.FileSearch since Microsoft Office 2007. Which one to use
depends on the specific needs. Sometimes, the VBA function Dir() can do
the job, sometimes CreateObject("Scripting.FileSystemObject") and
..FileExists can be used. A comprehensive re-write seems to be at
<http://www.mrexcel.com/forum/excel-...-filesearch-code-replacement.html#post2551004>.

Good luck.

 

[Markus Pflugrad]

Thanx a lot Michael.

I will have a look to it

 

[Markus Pflugrad]

puh ok - the code in general seems to be ok.

But I have no chance to include it in the right way into the existing form :-(