If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Automatic Link Queston on Open
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 |
#3
|
|||
|
|||
Automatic Link Queston on Open
"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 |
Thread Tools | |
Display Modes | |
|
|