I used to employ import/export and copy/paste from P331 into Excel - doing a variety of things from data analysis to resource loading - to make reports that weren’t possible in P331 or to re-import tagged tasks for filtering. Most only took minutes. Is the VBA/ADO using the SDK connection the best bet for import/export? Thanks...
Member for
22 years 11 months
Member for22 years11 months
Submitted by Bernard Ertl on Fri, 2004-09-17 18:58
You should be able to use VBA to access the ADO interface from Microsoft Office applications and make changes in "real" time. Our eTaskMaker software is exporting estimates/schedules to P3e[/c] using the ADO interface and it works fine.
Member for
21 years 1 monthRE: Connecting to PrimaveraSDK via Open Office
PrimaveraSDK.xls is on the Documetation disk that comes with P3ec under the support tab
Member for
24 years 7 monthsRE: Connecting to PrimaveraSDK via Open Office
Where did you find "PrimaveraSDK.xls".
I cant find it.
Member for
21 years 1 monthRE: Connecting to PrimaveraSDK via Open Office
"Is the VBA/ADO using the SDK connection the best bet for import/export? Thanks..."
from past implementation,
yes, VBA/ADO is absolutely the answers for what you needed to do.
Vu
Member for
22 years 11 monthsRE: Connecting to PrimaveraSDK via Open Office
I have not explored the alternatives, but the ADO interface works well enough for me. :)
Bernard Ertl
InterPlan Systems - eTaskMaker Project Planning Software
Member for
21 years 1 monthRE: Connecting to PrimaveraSDK via Open Office
Bernard
I used to employ import/export and copy/paste from P331 into Excel - doing a variety of things from data analysis to resource loading - to make reports that weren’t possible in P331 or to re-import tagged tasks for filtering. Most only took minutes. Is the VBA/ADO using the SDK connection the best bet for import/export? Thanks...
Member for
22 years 11 monthsRE: Connecting to PrimaveraSDK via Open Office
You should be able to use VBA to access the ADO interface from Microsoft Office applications and make changes in "real" time. Our eTaskMaker software is exporting estimates/schedules to P3e[/c] using the ADO interface and it works fine.
Bernard Ertl
InterPlan Systems - eTaskMaker Project Planning Software