One of my clients is still on GP 8.0 and uses Project Accounting with over 100 companies. They spend Saturday and Sunday every week to run PA reconcile process on about 50+ companies each day. The list of companies is dynamic so I use an SQL Table and have them mark Saturday and Sunday columns as “true” so the routine would know which companies to reconcile.
1. We use login macro automation to log into the first company.
2. We use your Toolbar package and in VBA pull the first company selected for this day and create Change Company Macro
3. From VBA using your code we execute the newly created Change Company Macro.
4. Per client we need to wait 45 seconds before calling a “PA Reconcile” Macro.
a. Some companies are done in seconds, some takes almost one hour.
5. We would like after the PA Reconcile Process is finished (I assume that we can use a code on a window close event ) to take the next Company from the list and keep repeating steps 3 -5 until all of the selected for the day companies are done.
I started testing and noticed when I start a wait (using kernel32 Sleep function) everything freezes.
Is there a way to put a pause/wait period after running Change Company Macro and before running PA Reconcile Macro.
Also, they are not able to disable a screen saver – will the screen saver interfere with the VBA and Macro process.
They would like to start this process as a scheduled task – so the workstation/server could be logged off, or a remote session disconnected.
Could we accomplish our goals by using GP Macros and VBA?
Thanks,
