Open and Save Projects automatically

[Ian Wolstenholme]

Hello,

Does anyone have any ideas on how we might open, save and close each project
in our Database automatically please ?

We have 350 projects and to do it manuallt is very tedious.

We need to do this to ensure updated resource availability and accurate
calculation of custom fields with formulas.

Thanks

Ian

 

[Kishore]

Hi Ian,
You can use the following approach:
Step1: Run SQL Statement to get the projects
Select * from msp_projects where proj_type = 0 order by proj_id
Step2: Loop through recordset and Open project(s)
strPjName = objrs.Fields("Proj_Name")
FileOpen "<>\" & strPjName, vbReadOnly
Step3: Do the stuff....and then save
FileSave
or
FileSaveAs ("<>\File Name.Published")
Step4: Close the File
FileClose
Step4: Close and cleanup record set, connection etc

Hope this helps...

Regards,
Kishore
ps: if you like the solution, rate my post.