Debugging ExportTablesToExcelFiles Script for SPSS Statistics 23

Question

I am trying to run the IBM script ExportTablesToExcelFiles script (wwd version) for SPSS Statistics 23 in Windows 10.

The script allows you to export SPSS output to individual Excel worksheets in a workbook.

I get this error:

The script apparently cannot get past the first few lines:

In the SPSS output window, I receive "ERROR: (16305) No error.."

I tried the fix PM40090: "ERROR : (16305) NO ERROR." RECEIVED WHEN RUNNING WINWRAP BASIC SCRIPT ON A 64-BIT IBM SPSS STATISTICS 19 CLIENT, but it did not work.

Has anyone resolved this issue in with SPSS 23 and Windows 10?

Answer 1

I just resolved this issue after a day of searching and trying stuff.

Solution that worked for me was to re-register the spss*.tlb and the spsswin.dll located in C:\Program Files\Common Files\IBM\SPSS\COM. The problem I had was a missing regtlibv12.exe which I hade to copy from a Win7.

• Copy the regtlibv12.exe from a Windows 7 located in C:\Windows.old\Windows\Microsoft.NET\Framework\v4.0.30319.
• Paste the regtlibv12.exe to the COM folder mentioned above.

• Open the Shell (CMD) and go to C:\Program Files\Common Files\IBM\SPSS\COM

  • Enter the following commands:

  regtlibv12.exe "C:\Program Files\Common Files\IBM\SPSS\COM\spssgctl.tlb"

  regtlibv12.exe "C:\Program Files\Common Files\IBM\SPSS\COM\spsspvt.tlb"

  regtlibv12.exe "C:\Program Files\Common Files\IBM\SPSS\COM\spssrtf.tlb"

  regtlibv12.exe "C:\Program Files\Common Files\IBM\SPSS\COM\spsswin.tlb"

  regtlibv12.exe "C:\Program Files\Common Files\IBM\SPSS\COM\treeview.tlb"

  regtlibv12.exe "C:\Program Files\Common Files\IBM\SPSS\COM\vischart.tlb"

  regsvr32 spsswin.dll

After this the scripts found the correct libraries / references again.