VB script to take a pivot table and be able to parse it like the one attached.

Are you looking for something like this?

' Define Needed constants
Const xlUp = -4162

' Define Excel file to process
Const cExcelFile = "C:\EE\EE28226559\example.xlsx"

' Open Excel, hide it
Set oExcel = CreateObject("Excel.Application")
oExcel.Visible = False

' Access data from first sheets in first workbook
Set oMaster = oExcel.Workbooks.Open(cExcelFile, False, False)
Set oSheet = oMaster.Sheets(1)

' Iterate through all rows (skip header and total)
For iRow = 2 To oSheet.Cells(65536, "A").End(xlUp).Row - 1
   ' Get column A value when it changes
   sValue = Trim(oSheet.Cells(iRow, "A").Value)
   If sValue <> "" Then
      sTTO = sValue
   End If

   ' Get column B value when it changes
   sValue = Trim(oSheet.Cells(iRow, "B").Value)
   If sValue <> "" And sValue <> "Total" Then
      sSubTask = sValue
      Wscript.Echo sTTO & ", " & sSubTask
   End If
Next

oMaster.Close
oExcel.Quit

Select allOpen in new window

~bp

sorry i dont want u to think of it as an excel file, think of the data being in a pivot table object

I'll need a real world example of the date you are trying to process.

~bp

well the data is the same but in a pivottable object.. with the column a spanning multiple rows

Okay, so could you please prepare an actual excel workbook with the pivot table you want to pull data out of.  It's critical that the example you provide is exactly like the real files you will be working with, since extracting data from a pivot table relies on using the exact names of pivot fields, etc.

~bp

ok those are the exact names.. the pivot table is in memory so basically i outputed it into the excel document.

What do you mean by "the pivot table is in memory"?  As I understood it you wanted to process an Excel file, but that doesn't sound like the situation.  If it isn't, then please describe further where the data is coming from?

~bp

yea so actually i am grabbing it from a pivottable in a qlikview application and need to process it and export a report to excel