Excel to Ms Projects VBA Help

[Astriel]

Sponsored Links

Hi

I am building a macro in Excel that takes data from excel, copies it into a 3 dimensional array, performs a number of computations in the array and then copies and pastes the results into Ms Projects.

I am having issues with the copying and pasting the data from the array to Ms Projects. At present I have to loop through the array one data point at a time, copying it from the array and then moving to Projects and pasting it. Due to the size of the array, this process is taking upwards on 10 hours to perform.

Are there any functions in Projects that would allow me to :

1) Turn off the screen updating
2) Paste a one dimensional array into projects without looping through it
3) Or a means to copy large quantities of data from the array into projects without having to copy each point individually.

Any help would be greatly appreaciated! Thanks!

[Katty]

You can do one thing , export all the data of Excel to ms project by export data option in ms excel. When you export the data , you should create a map the relationship between the data fields in project and the column output. You can use ODBC to access to data in a heterogeneous environment of relational and non relational database. Basically project support Microsoft SQL Server, Oracle Server and XML. You should select file format and to export data. In export wizard you should export the data in proper field of the destination.