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:
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?
vba export spss winwrap
edited Nov 12 at 22:08
K.Dᴀᴠɪs
6,794112139
asked Aug 16 '16 at 16:51
RTrain3k
431513
add a comment |
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?
vba export spss winwrap
edited Nov 12 at 22:08
K.Dᴀᴠɪs
6,794112139
asked Aug 16 '16 at 16:51
RTrain3k
431513
Did you add the reference to the project?
– litelite
Aug 16 '16 at 16:54
@litelite I have not done that and I am not sure what that means. Do I need to actually alter the script?
– RTrain3k
Aug 16 '16 at 17:01
You have to add a reference to spss to tell vba that these types exists, because they do not exists in the base language. However, i never used WinWrapIDE so i do not know how to do it. So you will have to check the documentation. This usually done in the project settings and usually require little to no modification of the code
– litelite
Aug 16 '16 at 17:06
OK thanks, I will look into it.
– RTrain3k
Aug 16 '16 at 17:07
add a comment |
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?
vba export spss winwrap
edited Nov 12 at 22:08
K.Dᴀᴠɪs
6,794112139
asked Aug 16 '16 at 16:51
RTrain3k
431513
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?
vba export spss winwrap
vba export spss winwrap
edited Nov 12 at 22:08
K.Dᴀᴠɪs
6,794112139
asked Aug 16 '16 at 16:51
RTrain3k
431513
edited Nov 12 at 22:08
K.Dᴀᴠɪs
6,794112139
asked Aug 16 '16 at 16:51
RTrain3k
431513
edited Nov 12 at 22:08
K.Dᴀᴠɪs
6,794112139
edited Nov 12 at 22:08
K.Dᴀᴠɪs
6,794112139
edited Nov 12 at 22:08
K.Dᴀᴠɪs
6,794112139
6,794112139
asked Aug 16 '16 at 16:51
RTrain3k
431513
asked Aug 16 '16 at 16:51
RTrain3k
431513
asked Aug 16 '16 at 16:51
RTrain3k
431513
431513
Did you add the reference to the project?
– litelite
Aug 16 '16 at 16:54
@litelite I have not done that and I am not sure what that means. Do I need to actually alter the script?
– RTrain3k
Aug 16 '16 at 17:01
You have to add a reference to spss to tell vba that these types exists, because they do not exists in the base language. However, i never used WinWrapIDE so i do not know how to do it. So you will have to check the documentation. This usually done in the project settings and usually require little to no modification of the code
– litelite
Aug 16 '16 at 17:06
OK thanks, I will look into it.
– RTrain3k
Aug 16 '16 at 17:07
add a comment |
Did you add the reference to the project?
– litelite
Aug 16 '16 at 16:54
@litelite I have not done that and I am not sure what that means. Do I need to actually alter the script?
– RTrain3k
Aug 16 '16 at 17:01
You have to add a reference to spss to tell vba that these types exists, because they do not exists in the base language. However, i never used WinWrapIDE so i do not know how to do it. So you will have to check the documentation. This usually done in the project settings and usually require little to no modification of the code
– litelite
Aug 16 '16 at 17:06
OK thanks, I will look into it.
– RTrain3k
Aug 16 '16 at 17:07
Did you add the reference to the project?
– litelite
Aug 16 '16 at 16:54
Did you add the reference to the project?
– litelite
Aug 16 '16 at 16:54
@litelite I have not done that and I am not sure what that means. Do I need to actually alter the script?
– RTrain3k
Aug 16 '16 at 17:01
@litelite I have not done that and I am not sure what that means. Do I need to actually alter the script?
– RTrain3k
Aug 16 '16 at 17:01
You have to add a reference to spss to tell vba that these types exists, because they do not exists in the base language. However, i never used WinWrapIDE so i do not know how to do it. So you will have to check the documentation. This usually done in the project settings and usually require little to no modification of the code
– litelite
Aug 16 '16 at 17:06
You have to add a reference to spss to tell vba that these types exists, because they do not exists in the base language. However, i never used WinWrapIDE so i do not know how to do it. So you will have to check the documentation. This usually done in the project settings and usually require little to no modification of the code
– litelite
Aug 16 '16 at 17:06
OK thanks, I will look into it.
– RTrain3k
Aug 16 '16 at 17:07
OK thanks, I will look into it.
– RTrain3k
Aug 16 '16 at 17:07
add a comment |
2 Answers
2
active
oldest
votes
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 FilesCommon FilesIBMSPSSCOM.
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.oldWindowsMicrosoft.NETFrameworkv4.0.30319.
- Paste the regtlibv12.exe to the COM folder mentioned above.
Open the Shell (CMD) and go to C:Program FilesCommon FilesIBMSPSSCOM
- Enter the following commands:
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspssgctl.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspsspvt.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspssrtf.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspsswin.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMtreeview.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMvischart.tlb"
regsvr32 spsswin.dll
After this the scripts found the correct libraries / references again.
answered Aug 7 '17 at 7:14
Hagbart Celine
345423
add a comment |
This is because of incorrect installation of SPSS. Please uninstall and then re-install whole of the SPSS (ensuring SPSS created folders in AppData are also removed before installing again). This will get resolved. It did for me.
Thanks.
answered Sep 6 '16 at 18:20
Ambrish
1
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f38980440%2fdebugging-exporttablestoexcelfiles-script-for-spss-statistics-23%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
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 FilesCommon FilesIBMSPSSCOM.
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.oldWindowsMicrosoft.NETFrameworkv4.0.30319.
- Paste the regtlibv12.exe to the COM folder mentioned above.
Open the Shell (CMD) and go to C:Program FilesCommon FilesIBMSPSSCOM
- Enter the following commands:
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspssgctl.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspsspvt.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspssrtf.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspsswin.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMtreeview.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMvischart.tlb"
regsvr32 spsswin.dll
After this the scripts found the correct libraries / references again.
answered Aug 7 '17 at 7:14
Hagbart Celine
345423
add a comment |
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 FilesCommon FilesIBMSPSSCOM.
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.oldWindowsMicrosoft.NETFrameworkv4.0.30319.
- Paste the regtlibv12.exe to the COM folder mentioned above.
Open the Shell (CMD) and go to C:Program FilesCommon FilesIBMSPSSCOM
- Enter the following commands:
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspssgctl.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspsspvt.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspssrtf.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspsswin.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMtreeview.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMvischart.tlb"
regsvr32 spsswin.dll
After this the scripts found the correct libraries / references again.
answered Aug 7 '17 at 7:14
Hagbart Celine
345423
add a comment |
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 FilesCommon FilesIBMSPSSCOM.
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.oldWindowsMicrosoft.NETFrameworkv4.0.30319.
- Paste the regtlibv12.exe to the COM folder mentioned above.
Open the Shell (CMD) and go to C:Program FilesCommon FilesIBMSPSSCOM
- Enter the following commands:
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspssgctl.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspsspvt.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspssrtf.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspsswin.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMtreeview.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMvischart.tlb"
regsvr32 spsswin.dll
After this the scripts found the correct libraries / references again.
answered Aug 7 '17 at 7:14
Hagbart Celine
345423
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 FilesCommon FilesIBMSPSSCOM.
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.oldWindowsMicrosoft.NETFrameworkv4.0.30319.
- Paste the regtlibv12.exe to the COM folder mentioned above.
Open the Shell (CMD) and go to C:Program FilesCommon FilesIBMSPSSCOM
- Enter the following commands:
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspssgctl.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspsspvt.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspssrtf.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMspsswin.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMtreeview.tlb"
regtlibv12.exe "C:Program FilesCommon FilesIBMSPSSCOMvischart.tlb"
regsvr32 spsswin.dll
After this the scripts found the correct libraries / references again.
answered Aug 7 '17 at 7:14
Hagbart Celine
345423
answered Aug 7 '17 at 7:14
Hagbart Celine
345423
answered Aug 7 '17 at 7:14
Hagbart Celine
345423
answered Aug 7 '17 at 7:14
Hagbart Celine
345423
345423
add a comment |
add a comment |
This is because of incorrect installation of SPSS. Please uninstall and then re-install whole of the SPSS (ensuring SPSS created folders in AppData are also removed before installing again). This will get resolved. It did for me.
Thanks.
answered Sep 6 '16 at 18:20
Ambrish
1
add a comment |
This is because of incorrect installation of SPSS. Please uninstall and then re-install whole of the SPSS (ensuring SPSS created folders in AppData are also removed before installing again). This will get resolved. It did for me.
Thanks.
answered Sep 6 '16 at 18:20
Ambrish
1
add a comment |
This is because of incorrect installation of SPSS. Please uninstall and then re-install whole of the SPSS (ensuring SPSS created folders in AppData are also removed before installing again). This will get resolved. It did for me.
Thanks.
answered Sep 6 '16 at 18:20
Ambrish
1
This is because of incorrect installation of SPSS. Please uninstall and then re-install whole of the SPSS (ensuring SPSS created folders in AppData are also removed before installing again). This will get resolved. It did for me.
Thanks.
answered Sep 6 '16 at 18:20
Ambrish
1
answered Sep 6 '16 at 18:20
Ambrish
1
answered Sep 6 '16 at 18:20
Ambrish
1
answered Sep 6 '16 at 18:20
Ambrish
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f38980440%2fdebugging-exporttablestoexcelfiles-script-for-spss-statistics-23%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Did you add the reference to the project?
– litelite
Aug 16 '16 at 16:54
@litelite I have not done that and I am not sure what that means. Do I need to actually alter the script?
– RTrain3k
Aug 16 '16 at 17:01
You have to add a reference to spss to tell vba that these types exists, because they do not exists in the base language. However, i never used WinWrapIDE so i do not know how to do it. So you will have to check the documentation. This usually done in the project settings and usually require little to no modification of the code
– litelite
Aug 16 '16 at 17:06
OK thanks, I will look into it.
– RTrain3k
Aug 16 '16 at 17:07