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..

"Don Guillett" wrote:

???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Allan" wrote in message
...
How can i Call JDE?

I can't do the "createobject".

Thanks much..