|Tags: access data project, data fields, excel to project, update task project|
| ||Thread Tools||Search this Thread|
Excel to Ms Projects VBA Help
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!
Re: Excel to Ms Projects VBA Help
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.
Last edited by Katty : 12-12-2009 at 01:00 AM.
|Thread Tools||Search this Thread|
|Similar Threads for: "Excel to Ms Projects VBA Help"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Help in PHP mini Projects .||niityam||Software Development||2||13-08-2010 09:24 AM|
|Help with Multiple Projects||monksb||Windows Software||1||21-08-2009 10:03 PM|
|Some of the Cool .Net Projects||Sam.D||Software Development||2||27-06-2009 09:32 PM|
|Master and Sub projects||BowlingKaz||Windows Software||3||16-12-2008 01:51 PM|
|I want some c++ & vb projects!||Snehasis||Education Career and Job Discussions||3||04-10-2008 01:02 PM|