This may have more general VFP OLE to VBA symptom that I don't understand, but here's the specifics.
Has anyone ever tried the following?:
Controlling Project 98 from VFP to hit an Oracle database containing the Project file?
I can get VFP to open Project using:
xmsp=createobject("msproject.application.8")
I then make it visible:
xmsp.visible=.t.
I can even do this:
xmsp.FileOpen("
\Project Name","False")
which makes me then enter the pasword to open the oracle database
but I can't do this:
xmsp.FileOpen(Name:="\Project Name",Readonly:=FALSE,
UserID:="username", DatabasePassWord:="paswd",
FormatID:="MSProject.ODBC.8")
or this:
xmsp.FileOpen("\Project Name","FALSE",,,,,,
"username", "paswd", "MSProject.ODBC.8")
When I try putting the whole thing in quotes to pass it as a single string or try using a variable to pass it the string, it tries to open a file with the entire string as the name.
How do I pass the parameters the values it wants?
Many thanks in advance!
Laurisa Watkins
Seattle City Light
laurisa.watkins@ci.seattle.wa.us