export msp_calendar_data

P

Polina

Hello,

is it possible to export the msp table "msp_calendar_data" via ODBC to
Oracle DB programmatically?

Or does exist any other way to get (with vba) the information for each
day if it is a working day or not?

Thank you a lot for your help.
Polina
 
P

Polina

Yes, thank you! The following is working fine:

For Each res In ActiveProject.Resources
If res.Calendar.BaseCalendar.Period(start_date, end_date).Working = False
Then MsgBox "No working day"
Else: MsgBox "Working day"
End If
Next

But what about the export of the msp tables?
 
J

Jan De Messemaeker

Hi,

At one point in time you asked for a solution via VBA which I provided.
I unfortunately do not know Project's data bases so I can't help you with
"msp_calendar_data"
Sorry
 
Top