One thing you may consider is creating a map using the Export Wizard. Once you have created a map containing the fields you wish to have in Excel you can create a macro to dump the data to Excel.
But copying the data will also work well for most all situations.
Example macro:
Sub...
First, thank you both for your responses. I have tried this approach but it will not meet my need.
Perhaps I should further explain the scenerio. I need to manage a turnaround with a scope of >2000 tasks. The majority of the jobs will be worked 6 am - 6 pm each day, 6 days a week. Within...
I am looking for a way to manage a task that will be worked around the clock using the same resource with that resource available in 2 shifts. How can this best be accomplished using MS Project?
Any help would be greatly appreciated
I am trying to enter a formula to calculate a text field based on the Resource Name. What I want to do is test the resource name to see if it CONTAINS a certain string. The only options I see are =, <>, <, > . Below is an example of what I am using but it is not exact.
IIf([Resource...