Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 5/Oracle and Project 98
Message
From
19/10/1999 16:27:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
VFP 5/Oracle and Project 98
Miscellaneous
Thread ID:
00278457
Message ID:
00278457
Views:
61
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
Next
Reply
Map
View

Click here to load this message in the networking platform