User Tools

Site Tools


spreadsheets

Spreadsheets

2026 08 01

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

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
spreadsheets.txt · Last modified: 2026/08/01 16:39 by donald