Export Task information-Tasks due this month

[CB]

I would like to have a report that would allow me to export all tasks due
this month to html or excel format which holds the outline format
(indentation). I can apply the autofilter on the finish and this seems to be
exactly what I need. Is there a way in VBA to run something monthly that
applies this filter and sames to .html format? All help appreciated.

 

[John]

I would like to have a report that would allow me to export all tasks due
this month to html or excel format which holds the outline format
(indentation). I can apply the autofilter on the finish and this seems to be
exactly what I need. Is there a way in VBA to run something monthly that
applies this filter and sames to .html format? All help appreciated.

CB,
Go to fellow MVP, Jack Dahlgren's website at:
http://masamiki.com/project/macros.htm, and take a look at his macro
called, "export hierarchy to Excel". A little tweaking using the
FilterApply Method and the SaveAs Method (for saving as a web page)
should round out what you want.

John
Project MVP