Auto Exit Great Plains

[baugie]

Hello All;

I am in the last stage or developing an automated integration system, and have one last hurdle, I hope

Does anybody have a good method that will automtically close Great Plains? I know the vbScript within Integration Manager doesn't work properly. I have tried using a SendKeys method within Visual Basic (which the system is developed in) to no avail.

I have terminated it from my VB app., but it does not close it cleanly and processes hang on each future instance of G.P. closing on that machine without a re-boot.

Any help is appreciated!!

Thanks in advance,

baugie

 

[winthropdc]

Most methods of exiting Great Plains create some sort of background process which in turn prevents the application from exiting.

The method I have used before is to run a macro which has previously recorded the File >> Exit steps. Infact, I have Dexterity code which creates a macro file with these instructions and then runs the macro.

This was the technique I used for Omni Password's Inactivity Timeout feature, before I left Winthrop. See

http://www.winthropdc.com

for more info.

David Musgrave
Senior Development Consultant
Asia Pacific Professional Services

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

mailto:dmusgrav@microsoft.com

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

 

[Dukester0122]

winthropdc - welcome to this forum. hope we give you good advice and vice versa.

 

[baugie]

winthropdc;

thanks for the idea. are you running this macro from vba code then? i need to close it from a process externally from Great Plains. I have had the problem of it hanging. I even tried some send keys tricks to try and get the File Menu, but GP wouldn't accept them.

My options are using my visual basic application to close GP or use a script in Integration Manager. I havn't found a solid solution yet, so I am going to have to baby the process by periodically checking for log out problems.

thanks in advance for the help

baugie

 

[winthropdc]

The code I already developed was all Dexterity code. However there is a way to execute Dexterity code from VBA, but it is not supported.

However, I have had it working perfectly for projects I have worked on.

David Musgrave
Senior Development Consultant
Asia Pacific Professional Services

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

mailto:dmusgrav@microsoft.com

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

 

[baugie]

I am not trying to close Great Plains from the VBA code, but from an external application using Visual Basic. I have been using the SendMessage method. However, occassionally I notice that when I try to close GP manually after using this method it will hang. This does not happen often, but once is too much when you want to create an automated process.

Thanks

 

[winthropdc]

You can execute Dexterity SanScript code from VB with Continuum as well. So the Macro method could be employed from your VB application.

David Musgrave
Senior Development Consultant
Asia Pacific Professional Services

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

mailto:dmusgrav@microsoft.com

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.