Search code examples
vbaexportspsswinwrap

Debugging ExportTablesToExcelFiles Script for SPSS Statistics 23

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: enter image description here

The script apparently cannot get past the first few lines: enter image description here

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?

Solution

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