View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Danny[_4_] Danny[_4_] is offline
external usenet poster
 
Posts: 17
Default Updating Links in Excel

I have a spreadsheet which retrieves data from several
other spreadsheets. When i open this spreadsheet it asks
me would i like to update the links and i click Yes and my
data is now current.

Does anyone know the code for this update. I want a button
which will run the same script as when i click Yes on
entry to the spreadsheet to update the links.

Thanks,

Danny.