Pivot Table RRS feed

  • Question

  • I appreciate if anyone can help in this. I have this simple code to create a pivot table. It works fine excpet that the data does not come out under the Data Area. When the excel sheet is create, i have to right-click on DATA Column header, and select "move values to columns". This is the code:

    SET DEFAULT TO c:\temp


    WITH oBook




     oPivottable.PivotFields["Debit"].Orientation =xlDataField


    • Moved by Wesley Yao Monday, November 9, 2009 5:26 AM vb question (From:Visual C++ Language)
    • Moved by Martin Xie - MSFT Wednesday, November 11, 2009 7:46 AM Redirect to appropriate forums for better responses. (From:Visual Basic Language)
    Thursday, November 5, 2009 12:24 PM


All replies