Search results for query: *

Thanks for the input on the speed, and thanks for input on the code. I'll have to get with our IT folks and find out what they did with our version that makes it so slow. I have some complex macros for taking data from another system and putting it into Project that run 50 minutes for a 5,000...

Open the file or down load it and run the macro and tell me how long it takes to run. When I run it in 2003 it displays a 0 or 1. When I run it in 2007 it displays 15 or 20. The macro is A_SpeedTest. BTW, I am having no problems with Excel 2007. Thanks

The problem I am having is much bigger than the format of the time command. It has to do with looping through the project. I have attached the test file.http://members.cox.net/rmarsh3772/MSP2007Test1.mpp

Thanks for the responses. Here is the macro Sub A_SpeedTest() Dim oTask As Task Dim xDateIn As String Dim xDateOut As String xDateIn = Format(Time, "HH:mm:SS") SelectAll For Each oTask In ActiveProject.Tasks oTask.Name = "Task " + Format(oTask.ID) Next oTask xDateOut = Format(Time...

We are currently in the process of updating from Project 2003 to Project 2007. Very simple macros that run just fine in 2003 take forever in 2007. Our tech guy tried in 2010 and said it runs just as slow there. Same machine, same file, same macro. Consistent across all machines. Has anyone...