Guys
I have a procurement programme in MSP which I have linked to an excel file. I have a planned, actual an forecast date for each activity, and about 15 activities per package. I have a reference programme with 115 packages. I then copy and rename to suit a new project. The problem I have is that the excel file is extremely slow and the connections seem fragile to say the least. Is there anyone out there who can give me a specific code to export the baseline, actual and current date to a specific cell in excel. I know absolutely nothing about Visual basic, and I am following up a previous thread in which I was given various places to look up, but did not give me the answer I am looking for. It does not have to necessarily export to excel, but produce a report which gives the package on the left with the planned actual and forecast dates for each activity in a spreadsheet fashion.
Thankyou in advance - a frustrated planner
I have a procurement programme in MSP which I have linked to an excel file. I have a planned, actual an forecast date for each activity, and about 15 activities per package. I have a reference programme with 115 packages. I then copy and rename to suit a new project. The problem I have is that the excel file is extremely slow and the connections seem fragile to say the least. Is there anyone out there who can give me a specific code to export the baseline, actual and current date to a specific cell in excel. I know absolutely nothing about Visual basic, and I am following up a previous thread in which I was given various places to look up, but did not give me the answer I am looking for. It does not have to necessarily export to excel, but produce a report which gives the package on the left with the planned actual and forecast dates for each activity in a spreadsheet fashion.
Thankyou in advance - a frustrated planner