Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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")
Use similar code to select a customer:
ActiveDocument.Fields("Customer").Select "Joe Blow"
From the API Guide:
ActiveDocument.Fields("Month").Select "September"
ActiveDocument.Fields("Month").Select "J*"
ActiveDocument.Fields("Sales").Select ">1500"
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.
Use similar code to select a customer:
ActiveDocument.Fields("Customer").Select "Joe Blow"