Consulting

Results 1 to 4 of 4

Thread: Export to excel for each resource

  1. #1
    VBAX Newbie
    Joined
    Feb 2008
    Posts
    4
    Location

    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

  2. #2
    VBAX Newbie
    Joined
    Feb 2008
    Posts
    4
    Location
    Solved my own problem with a SelectAll

  3. #3
    VBAX Newbie
    Joined
    Mar 2008
    Posts
    2
    Location
    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

  4. #4
    VBAX Newbie
    Joined
    Mar 2008
    Posts
    1
    Location
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •