XlSheet.cells(2, 5).Value = pj.ProjectFinish XlSheet.cells(2, 4).Value = "Project Finish" XlSheet.cells(1, 5).Value = pj.ProjectStart XlSheet.cells(1, 4).Value = "Project Start" XlSheet.cells(2, 1).Value = "Project Title" XlSheet.cells(1, 1).Value = "Project Name" It is possible, I have a MACRO that does that for years.
I'm pretty new to this and not sure if this is even possible or if it is possible and just so complicated that its not even worth it. If anyone has any better suggestions please let me know.
Screenshot of current MS project output in Excel XlSheet.Cells(t.ID + 4, (7 * i) + 11).Interior.ColorIndex = 37 XlSheet.Cells(t.ID + 4, (7 * i) + 10).Interior.ColorIndex = 37 XlSheet.Cells(t.ID + 4, (7 * i) + 9).Interior.ColorIndex = 37 XlSheet.Cells(t.ID + 4, (7 * i) + 8).Interior.ColorIndex = 37 XlSheet.Cells(t.ID + 4, (7 * i) + 7).Interior.ColorIndex = 37 XlSheet.Cells(t.ID + 4, (7 * i) + 6).Interior.ColorIndex = 37 'Loop to add day of week headers and color cells to mimic Gantt chart XlSheet.Cells(t.ID + 4, 4).Value = t.Finish XlSheet.Cells(t.ID + 4, 3).Value = t.Start XlSheet.Cells(t.ID + 4, 2).Value = t.Name XlSheet.Cells(4, 4).Value = "Task Finish" XlSheet.Cells(2, 1).Value = "Project Title" XlSheet.Cells(1, 1).Value = "Project Name" I don't know how to color the correct number of cells(right now it colors cells in multiples of 7, or weeks at a time instead of down to the specific day. I don't know how to add an offset for each specific task depending on what day it starts onĢ. So what I've tried so far(since excel doesn't have a built in Gantt maker) is to make the chart on the spreadsheet, coloring the cells to mimic a Gantt chart. I know I know, what's the point of going through all this just to get a Gantt chart in Excel when I already have one in Project right? Well among other things this Excel gantt chart is being made so that everyone without MS Project can view the scheduled tasks without having MS Project. What I'm trying to do now is take that data in Excel and replicate into a Gantt chart similar to the one in Project. So far I am able to export the data I want with no issue and it opens in Excel just fine. I'm trying to export some tasks from MS Project to Excel using a VBA script in Project.
0 kommentar(er)
