Spreadsheets

Support Team DGKbox orderskeys@gmail.com 9/9/2025

Hello, please use new key N2P2T-4JTXK-KRMB6-HGVJW-82VGD Warm regards, The Team at Digitalkeysbox.com and CEO James Branch

• 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

• 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.

• 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