Excel and JD Edwards

  • Thread starter Thread starter Allan
  • Start date Start date
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..
 
what is "JDE.System"?



Allan said:
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..
Click to expand...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Send info to other apps from Excel 2
db2 w/access 1
AS400 connection problems 2
Current Date to JDE Julian 2
SQL clause 7
Detect whether there is an account configured in Outlook 3
excel 2007 macro recorded pivot table 2
Error message instead of parameter box appearing 1

Back
Top