Automatic Link Queston on Open

I have about 4000 spreadsheets, all with links to a single spreadsheet to
pick up some rate fields. I am now trying to convert those Spreadsheets to
a FoxPro database. I can open each of the spreadsheets from within FoxPro,
but when I open each one I get the message concerning automatic links and
whether I want to update data from these links. For my processing, I don't
need to update, but I would like to get rid of the message. I want my
program to just scroll through all the .xls files in the directory without
operator intervention, but now I am getting the question once per
spreadsheet. I get the same message if I just open the spreadsheet in
normal excel.

Is there some parameter in excel that I can set to cause this message to
take the default?

Not sure what kind of command you are using to open the files but the
following will open a file without updating the links

Workbooks.Open filename:=NameOfFile, UpdateLinks:=0

"JS" wrote in message
...
Not sure what kind of command you are using to open the files but the
following will open a file without updating the links

Workbooks.Open filename:=NameOfFile, UpdateLinks:=0


Thanks, that gave me the direction. I am using the excel.workbooks.open

command. The first parameter is the workbook to open. The second parameter

is Update links

= Excel.Workbooks.open("My Workbook.xls",0)

This command to open the first file did the trick.

Alan