By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,557 Members | 1,406 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,557 IT Pros & Developers. It's quick & easy.

Use VB to login into Avante

P: 7
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
Jun 19 '08 #1
Share this Question
Share on Google+
5 Replies


Dököll
Expert 100+
P: 2,364
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:-)
Jun 20 '08 #2

P: 7
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
Jun 20 '08 #3

debasisdas
Expert 5K+
P: 8,127
What this Avante is ?
Jun 20 '08 #4

P: 7
Avante is ERP system designed and licensed by Epicor Software Corp
Regards
Mike
Jun 20 '08 #5

P: 7
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\explorer\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
Oct 27 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.