on 10-17-2014 12:13 PM
Hey all
I'm sorry to ask but i cant find ths answer...
When i run a script in vba the window takes over when obtaining data from SAP ( client records in 'pa20')
For a couples its fine but when doing a lot i could being doing another task or looking on eBay
Can you set the window to stay minimised when running or at least if its runs into an error to show the window ?
Thanks
Pav.
Hello Pavle:
As far as I know, VBA in an Office application does not support multithreading, which would be the ideal approach.
In fact, this weekend I am updating code that does exactly as above (transfers tables of data from an SAP system to a local file or Access database) in a background process, using a BackgroundWorker. This approach means that the application's user interface is not stopped while SAP components transfer data; a user can continue to perform other activities with the application while the data transfers from SAP.
Of course, all this is done using Visual Studio .NET and not VBA. It's one of several reasons that I abandoned VBA two years ago for this particular application.
- Paul
-------------------------------
Paul R Gendreau, Jr.
SAP Retail
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
BackgroundWorker is working fine. Keep in mind that this is just an enhancement for an already robust process. I had already created a class with many features as a wrapper for the process of downloading data from an SAP system.
There are many examples to use as a concept for getting started ... such as
http://scn.sap.com/docs/DOC-45293
- Paul
-------------------------------
Paul R Gendreau, Jr.
SAP Retail
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.