This is an old revision of the document!

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

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"

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

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

=INDIRECT.EXT("[prices.xls]"& "ArmModelVan2" & "!" & a1)

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

MacQueen

Table of Contents

Spreadsheets

2025 05 24

2025 05 24

Earlier