Excel and JD Edwards

[Allan]

How can i Call JDE?

I can't do the "createobject".

Thanks much..

 

[Don Guillett]

???

 

[Allan]

would you know the syntax or codes on how to create JDE in excel, so i can
create macros in excel that will sendkeys in JDE.
this is not working:


Public Sub CreateJDE()
Dim Sys As Object
Dim Sess As Object
Dim MyScreen As Object
'Enter to system
Set Sys = CreateObject("JDE.System")
' Assumes an open session
Set Sess = Sys.ActiveSession
Set MyScreen = Sess.Screen
End Sub

Thank You..

 

[Patrick Molloy]

what is "JDE.System"?

would you know the syntax or codes on how to create JDE in excel, so i can
create macros in excel that will sendkeys in JDE.
this is not working:


Public Sub CreateJDE()
Dim Sys As Object
Dim Sess As Object
Dim MyScreen As Object
'Enter to system
Set Sys = CreateObject("JDE.System")
' Assumes an open session
Set Sess = Sys.ActiveSession
Set MyScreen = Sess.Screen
End Sub

Thank You..

 

[Tim Williams]

http://en.wikipedia.org/wiki/J._D._Edwards ?

Tim

 

[Allan]

jde's file extension is .wm
now can i have the answer to my question?

 

[Don Guillett]

Maybe not...

 

[Tim Williams]

I'm not sure anyone here knows what "JDE" really is, and you're not
helping us at all.
How about a link to some documentation or some idea of what you're
working with ?

You posted some code which is "not working", but what we'd need to
know first is what does it do *instead* of working ?
ie. what is the exact error message if any ?

Tim