====== Spreadsheets ======

===== 2025 05 24 =====

  * office 2010 expires in 30 days.
  * from this page (https://msguides.com/office-2010-2013), ran this code in an admin command prompt
  * <code>if exist "%ProgramFiles%\Microsoft Office\Office15\ospp.vbs" set folder="%ProgramFiles%\Microsoft Office\Office15"
  * if exist "%ProgramFiles(x86)%\Microsoft Office\Office15\ospp.vbs" set folder="%ProgramFiles(x86)%\Microsoft Office\Office15"
  * if exist "%ProgramFiles%\Microsoft Office\Office14\ospp.vbs" set folder="%ProgramFiles%\Microsoft Office\Office14"
  * if exist "%ProgramFiles(x86)%\Microsoft Office\Office14\ospp.vbs" set folder="%ProgramFiles(x86)%\Microsoft Office\Office14"</code>
  * 
  * <code>cscript %folder%\ospp.vbs /inpkey:VYBBJ-TRJPB-QFQRF-QFT4D-H3GVB
  * cscript %folder%\ospp.vbs /inpkey:YC7DK-G2NP3-2QQC3-J6H88-GVGXT
  * cscript %folder%\ospp.vbs /sethst:kms.msguides.com
  * cscript %folder%\ospp.vbs /setprt:1688
  * cscript %folder%\ospp.vbs /act</code>
  * had to run the last line twice

===== 2025 05 24 =====

  * office 2003 will not install on win 10
  * downloaded office 2010.
  * myfunc functions do not work on office 2010
  * change indirect.ext to indirect and converted .xls to xlsx
  * created a macro (ctrl-o) to open the links referenced in consolidatedDaily.xlsm.

===== Earlier =====

  * use indirect.ext to get data from closed spreadsheets
  * <code>=INDIRECT.EXT("[prices.xls]"& "ArmModelVan2" & "!" & a1)</code>
  * From the spreadsheet prices.xls and the worksheet ArmModelVan2, get the value in the cell A1 __in the current sheet__
  * the whole thing is '[prices.xls]ArmModelVan2!A1 because the value in A1 __in the current sheet__ is A1
  * I cannot figure out how to quote A1 directly

