Recording Macro

[Biggles]

I want to use timescaled data for my analysis, and there are reports I want
to create on a weekly basis. I turned on the macro recorder and then set my
filter and ran the analyze time scale data in Excel wizard, however, only the
setting of the filter was recorded in the macro. I would like to do
everything in VBA if possible, and if that means re-creating what is done in
the wizard, that is fine.

Does anyone know where I can see some examples of that code or the
methodology involved?

Thanks

 

[John]

I want to use timescaled data for my analysis, and there are reports I want
to create on a weekly basis. I turned on the macro recorder and then set my
filter and ran the analyze time scale data in Excel wizard, however, only the
setting of the filter was recorded in the macro. I would like to do
everything in VBA if possible, and if that means re-creating what is done in
the wizard, that is fine.

Does anyone know where I can see some examples of that code or the
methodology involved?

Thanks

Biggles,
As you found out the macro recorder will not "catch" everything and put
it into code. Exporting timescaled data is a very common use of VBA.
However, if you are using Project 2007, you might want to try using the
Visual Reports feature first, before writing your own VBA macro.

If you do decide that VBA is the right choice for you, several examples
of code featuring the TimescaleData Method have been posted in this
newsgroup over the years. You could do a search and perhaps get what you
need. For a more complete treatment in one place, try fellow MVP, Rod
Gill's book on Project VBA. For more information, go to
http://www.projectvbabook.com.

Hope this helps.
John
Project MVP