onetruerick
11-27-2008, 08:24 PM
I have some Project VBA macros for downloading at my Web site, which I cannot reference here because my post count must be 5 or greater, which hopefully it will be soon. I can be be reached by email at yahoo, under the name onetruerick2008, and from there I can point you to my page, which is VBA followed by the usual extension for an HTML file (leave off the L). The name of the site is the word Electron followed by the word Automotive with no space in between, and it is a COMmercial site.
One of them is a timescaling/zoning macro (and from) for the Network Diagram view. Another is a logic tracing macro, and a third one compares two MS Project files and writes a report to Excel, highlighting the differences between the two files in red.
I have a lot of others, too, not on the page, but I can post them or email them to anyone who would like to try them. I have a logic report, macros that interact with Outlook (create Outlook tasks from Project tasks, create task start and finish reminders in Outlook calendar, etc.) and a lot of random ones. If you need some, just ask, I probably have it somewhere.
I have used Project since it was first introduced, even MacProject, and have been doing scheduling for over 25 years now. I also have a lot of experience doing schedule risk analysis (I do it for NASA now), and have my own Monte Carlo simulation tool, SCRAM2009. From my VBA page you can go to a YouTube demo of this program.
If you try any of the macros, please drop me a line with your questions or suggestions on improvements.
Thanks,
Rick W
One of them is a timescaling/zoning macro (and from) for the Network Diagram view. Another is a logic tracing macro, and a third one compares two MS Project files and writes a report to Excel, highlighting the differences between the two files in red.
I have a lot of others, too, not on the page, but I can post them or email them to anyone who would like to try them. I have a logic report, macros that interact with Outlook (create Outlook tasks from Project tasks, create task start and finish reminders in Outlook calendar, etc.) and a lot of random ones. If you need some, just ask, I probably have it somewhere.
I have used Project since it was first introduced, even MacProject, and have been doing scheduling for over 25 years now. I also have a lot of experience doing schedule risk analysis (I do it for NASA now), and have my own Monte Carlo simulation tool, SCRAM2009. From my VBA page you can go to a YouTube demo of this program.
If you try any of the macros, please drop me a line with your questions or suggestions on improvements.
Thanks,
Rick W