Automate linked information update in Excel

[sqlturbo]

I have links in Spread sheet1(MS Excel Spread sheet) that get data from cells in Spread sheet2. Data in Spread sheet1 gets updated after I open it. It basically ask me if I want to update all linked information and on a "yes" it gets the latest data.
Is there a way I could update Spread sheet1 without having to open it? I want to do this so that I can schedule transfer of data from Spread sheet1 to a SQL Server database wihtout having to open Spread sheet1.

Any help would be appreciated

 

[robcarr]

not sure if you can update without opening, what you can do is create a macro to open the book and then update the links automatically, using.


Application.screenupdating = false
Application.displayalerts = false
workbooks.open filename:=Spread sheet1 'filename of ss1
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
activeworkbook.close true
Application.screenupdating = True
Application.displayalerts = True

if you use the above coding it should open the workbook update links and then close, without being displayed on the screen.

reagrds

Thanks Rob.