VB Coding. Who's got the Knowledge?

Hi all,

I wonder if anyone can help me.

I am no good at coding on VB and need to set up a piece of code. I need the code to make a macro which will look up .xls files in a certain area of my documents, then update the links of that file, save the file, close the file and then move on to the next subsequent .xls file.

I have something shown below but it is not working.

Sub Auto_Update

With Application.FielSearch
.NewSearch
.Look In = "M:\forecasts 2007\Me\
.Search Sub Folders = False
.FileName = ".xls"

workbooks.open
Activeworkbook.Save
ActiveWindow.Close

Any suggestions??

Cheers

see your other post

Carim

O yes sorry,

I meant Application.FileSearch

Cheers

answer again in your other post ...