Export variable labels to Excel

Discussion in 'SPSS' started by Lutz, Nov 29, 2011.

  1. Lutz

    Lutz Guest

    Hey guys,

    got a problem with a script I found at the IBM Techbase:
    http://www-01.ibm.com/support/docview.wss?uid=swg21480727

    Can anyone check if it is working? I'm not sure because I don't
    understand the code and it wasn't working with my .sav file or a test
    file. Only a 0 Kb .txt file is the outcome.

    I think the failure is in this line:
    SpssTextData = objDataDoc.GetTextData (objSPSSInfo.VariableAt(0),
    objSPSSInfo.VariableAt(numVars), 1, lngNOC)

    Please help, I really don't want to do the work twice! =)

    Kind regards,
    Lutz
     
    Lutz, Nov 29, 2011
    #1
    1. Advertisements

  2. Can't help you with the VB code, however in case you don't have to
    automate this, I would suggest.

    Create a new syntax.
    Single statement: "DISPLAY VARIABLES."
    Copy the resulting output table.
    Paste it into your Excel sheet.
     
    Andreas Jaeger, Nov 29, 2011
    #2
    1. Advertisements

  3. Lutz

    Lutz Guest

    Thanks for your help. Your suggestion was right, I don't need an automation.
    Despite that, I deleted the post because I found a lot of other scripts which are doing the same thing and are working.

    Thanks a lot, tomorrow morning I can finish the task.
     
    Lutz, Nov 29, 2011
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.