export to excel with condition using macros

[#1]

Hi,

I want export to my datas to excel using macros but i want export my data with some condition

for example I have an table with date,name and data in that i have date from 11-02-2014 to 21-02-2014 my condition is  i want to export the data which is after 16-02-2014 i.e.,from 16-02-2014 to 21-02-2014.

I have attached a sample qvw file with this mail please help me..

Thanks in advance...

[#2]

thanks gonzalo this what i need but if there is chance for exporting those data without selection in a chart..?

[gonzaloruizgonz]

Yes, modifie the macro to this one:

Sub sat

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\test.xls", 5  

end sub