Use VB to login into Avante

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • macmacro64
    New Member
    • Apr 2008
    • 7

    #1

    Use VB to login into Avante

    Good Afternoon,

    As a novice vb programmer I have developed some cool code (by no means perfect) to ease my workload at busy times. I am now looking to auto run some reports from our accounting system.

    Can any of you direct me to some reading material that I should study before I begin.

    Basically, I want to open up an avante session, login and ask Avante to run some reports and store them for me somewhere.

    Many Thanks
  • Dököll
    Recognized Expert Top Contributor
    • Nov 2006
    • 2379

    #2
    Hey there macmacro64!

    Boy I have to say you sound very excited about this, would you post the code mentioned though, if you could it would be great..

    I can almost feel what you are saying because not to long ago I came here with the same attitude. Good luck with project:-)

    Comment

    • macmacro64
      New Member
      • Apr 2008
      • 7

      #3
      Hi Dokoll,

      Thanks for your prompt response.

      I haven't written any code for this yet. I am actually looking for a pointer for some reading material at this stage. My problem is I am not sure what I need to do and what the possible coding phrases I need/do. For example I have come across open channel and DDEInitiate to name but two but I am not too sure if I am even in the right area.

      My guess is I need to identify a pointer to the server, to Avante, open up some sort of channel with Avante, send it amy userid and passwrod and then send some keystrokes to get what I need done.

      I am not overly concerned about the keystrokes yet as there is a list in the help section providing some of these. What I can't seem to find is anything expalining the steps and process for initiating the process. Perhaps I might be better of delaying this development and learn more about opening other aspects of microsoft first: Am I trying to run before I can work (oops I mean walk).

      Best Regards
      Mike

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        What this Avante is ?

        Comment

        • macmacro64
          New Member
          • Apr 2008
          • 7

          #5
          Avante is ERP system designed and licensed by Epicor Software Corp
          Regards
          Mike

          Comment

          • macmacro64
            New Member
            • Apr 2008
            • 7

            #6
            Hi All,

            I am still trying to get into my Avante package. I have figured that I can use the RetVal to open my login window but am struggling to send my password. I have used a few variations using info I have found on the web. However, all attempts to send anything have failed.

            I have tried using 'sendkeys' to send to notepad, word etc and have had no luck whatsoever. What am I missing please? Do I need to define as object somehow?


            Sub OpenAvante()

            oShell = "C:\Program Files\avante\ex plorer\AVExplor .exe"
            RetVal = Shell(oShell, 1) ' Runs Avante Login.
            Sendkeys "xxxxxxxx"

            End Sub

            Note my aim is to log on and run some reports and save them somewhere. I am not an IT guy and they don't want me messing about using other methods. This way I will be limiting myself to access only modules I am allowed to.

            Many thanks
            Mike

            Comment

            Working...