The latest vSPD Excel interface won't work on Excel 2013 running on Windows 10 x64. The issue is that the “Microsoft Date and Time Picker Control 6.0 (SP4)” used on some of the forms is no longer distributed by Microsoft.

I managed to get it to work with a bit of hacking; note this isn't supported by Microsoft and could cause your system to crash or fail to boot so take care. The process I followed was:

  • Download VisualBasic6-KB896559-v1-ENU.exe and save
  • Open the file above in 7 Zip File Manager (or WinZip)
  • Extract the files to c:\windows\SysWOW64
  • Start a cmd prompt with admin rights
  • C:\Windows\SysWOW64> regsvr32 wmnetmgr.dll
  • C:\Windows\SysWOW64> regsvr32 mscomct2.ocx

Also note if you've opened the vSPD spreadsheet before doing the steps above, and then saved after it's errored, it'll corrupt it and you'll need to download it again.