MS Project VBA application
Budget: €30 – €250 EUR
Greetings,
I am in a need of VBA application for MS Project that will dynamically connect to MS Excel spreadsheet. I am working on an optimization tool that would basically take data from MS Project, save certain data entered in the MS Project and save it to a spreadsheet. The optimization tool uses that same data for optimization purposes (not a part of this task). The optimization tool then saves optimal result in a similar spreadsheet with a different name. So, the goal of this VBA tool would be to find the location where this MS Project file is located. In the same directory, there will be spreadsheets named InputData.xlsx and OutputData.xlsx. The first part of VBA functionalities would be to transfer data from MS Project to InputData.xlsx on InputData sheet:
1. Task Name
2. Successors
3. Cost1
4. Cost2
5. Cost3
6. Cost4
7. Cost5
8. Duration1
9. Duration2
10. Duration3
11. Duration4
12. Duration5
Afterwards, I would like to import the following data from OutputData.xlsx and OutputData sheet:
1. Task Name (it would be the same as before)
2. Start
3. Duration
4. Cost
It would be great if that connection could be dynamical, such as in the function “Paste with a dynamical link”. In other words, if I change some settings in MS Project, the data changes in MS Excel in real-time. Also, if I run the optimization tool multiple times and the data in OutputData.xlsx changes I would like that the data is automatically presented in MS Project.
I have been working quite a while on this project and I have already put some functionalities to this project, but they need some upgrades for better automation of this whole process. In the attachment is my MS Project file with input parameters for one of the simple projects to test these functionalities. The MS Project file has two VBA Modules, one for User form and another one as a trigger to start the optimization process. There are a few improvements that are needed. This User form, when started, requires from end user to enter some additional project information that is afterwards sent to the same excel file previously mentioned as InputData.xlsx. In its current state, this User form is opened as blank every time it is used. I would like that the data entered in the user form stay visible every time the form is started, except for the “Working time” and “Excel file location”. Also, there is another Module that triggers Excel macro within the InputData.xlsx but the path is set as fixed. I would like you to change that it is dynamical, so it reads where the MS Project file is stored and creates a path to the InputData.xlsx in the same directory.
The in-between connection between these three files is crucial for this system to work, and also, these connections should be created without too much setting up. For example, if I transfer these three files to another PC, it should be up and running. Also, it is very important that this whole process is scalable, so that there is no limitation on number of activities to be imported/exported.
If you have any questions or are in a need of clarification please fell free to ask.
Sincerely,
Bdasovic
I am in a need of VBA application for MS Project that will dynamically connect to MS Excel spreadsheet. I am working on an optimization tool that would basically take data from MS Project, save certain data entered in the MS Project and save it to a spreadsheet. The optimization tool uses that same data for optimization purposes (not a part of this task). The optimization tool then saves optimal result in a similar spreadsheet with a different name. So, the goal of this VBA tool would be to find the location where this MS Project file is located. In the same directory, there will be spreadsheets named InputData.xlsx and OutputData.xlsx. The first part of VBA functionalities would be to transfer data from MS Project to InputData.xlsx on InputData sheet:
1. Task Name
2. Successors
3. Cost1
4. Cost2
5. Cost3
6. Cost4
7. Cost5
8. Duration1
9. Duration2
10. Duration3
11. Duration4
12. Duration5
Afterwards, I would like to import the following data from OutputData.xlsx and OutputData sheet:
1. Task Name (it would be the same as before)
2. Start
3. Duration
4. Cost
It would be great if that connection could be dynamical, such as in the function “Paste with a dynamical link”. In other words, if I change some settings in MS Project, the data changes in MS Excel in real-time. Also, if I run the optimization tool multiple times and the data in OutputData.xlsx changes I would like that the data is automatically presented in MS Project.
I have been working quite a while on this project and I have already put some functionalities to this project, but they need some upgrades for better automation of this whole process. In the attachment is my MS Project file with input parameters for one of the simple projects to test these functionalities. The MS Project file has two VBA Modules, one for User form and another one as a trigger to start the optimization process. There are a few improvements that are needed. This User form, when started, requires from end user to enter some additional project information that is afterwards sent to the same excel file previously mentioned as InputData.xlsx. In its current state, this User form is opened as blank every time it is used. I would like that the data entered in the user form stay visible every time the form is started, except for the “Working time” and “Excel file location”. Also, there is another Module that triggers Excel macro within the InputData.xlsx but the path is set as fixed. I would like you to change that it is dynamical, so it reads where the MS Project file is stored and creates a path to the InputData.xlsx in the same directory.
The in-between connection between these three files is crucial for this system to work, and also, these connections should be created without too much setting up. For example, if I transfer these three files to another PC, it should be up and running. Also, it is very important that this whole process is scalable, so that there is no limitation on number of activities to be imported/exported.
If you have any questions or are in a need of clarification please fell free to ask.
Sincerely,
Bdasovic