Software

Ask something
Discussion Locked

VBA in Microsoft Project access to SQL server

0 helpful
2 replies

by vbabird

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Anyone knows how to write a macro in MS project to write user selected data in .mpp file to a table in SQL server db? Could Macro implement this? or I need to write a plug-in? I have no idea about this :(

2 replies

by mailtosteve2004-techrepublic

Is there a way to access the server sql tables from a Project macro? I?m trying to get the Summary Progress date from msp_web_assignments and use it to calculate a stoplight value in Project. The Summary Progress date is calculated but ?hidden?, you can see it only if you mouse over the summary progress bar in the gantt chart. My stoplights use the Complete Through date, so they don?t match the progress bar. Thanks, Steve

by persianie

Hi dear
I meet this problem too, and i need to help me. do u find the solution of this problem. if yes, can u let me to use this solution?
thanks

This discussion is closed to new replies.