Export to excel for each resource

I have found the script masamiki.com/project/export-hierarchy-to-excel.html to export to excel which is great as most the people dont have Project on their PC.

What I would like to do however is to be able to create on sheet per resource so they can effectively be handed out to the individual people.

Whilst I can filter tasks what I seem unable to do is to then work with that subset of tasks as after filtering the VBA still uses the complete set.

I am sure this will be an inefficient way to do it but it wont be used often so shouldnt be too bad.

How can I change the ActiveProject.Tasks to be simply the filtered/ currently visible tasks rather than all?

Many thanks

Solved my own problem with a SelectAll :)

Quote:

---

Originally Posted by Astaroth

Solved my own problem with a SelectAll :)

---

Hi There

i am busy with something similar and also used the code on that site but would you mind posting your code here so that I can have a look.

Cheers

Hey there, Astaroth ....

Like Absa, I wonder if you could post your solution?
I'm new to the whole VBA world and don't even understand how (or where) the 'SelectAll' statement would be implemented.

Your assistance and generousity would be greatly appreciated.

Regards