VBA code for sheetobject selection

[venkatasubramanian]

Hi There

i have selected the sheetobject using the belwo vba code, but i am not sure how to make filter/Selection in sheetobject (CH11), could you please help me on this

Set obj = doc.GetSheetObject("CH11")

[m_woolf]

From the API Guide:

ActiveDocument.Fields("Month").Select "September"

ActiveDocument.Fields("Month").Select "J*"

ActiveDocument.Fields("Sales").Select ">1500"

[venkatasubramanian]

I have tried this but it shows "Object doesn't support this property or method" error.

I will elaborate my question for more clarity, I need to make some selection (cyclic filter selection) in the objectsheet (sheet names in default shows CH11, CH51...) before i export that in the excel file.

I have made all the selection using the code Activedocument.GetField("Month").Select "Jul" and got an output in the object sheet, now i have to export Jul month data per customer/, to do that i have to make a selection (customer) in the output (object sheet) and export it in the excel file. I need a code to select customer in the output sheet.

[m_woolf · Accepted solution]

Use similar code to select a customer:

ActiveDocument.Fields("Customer").Select "Joe Blow"