I'm using VBA to connect to SAP to collect information. The T/C I'm calling though takes a little bit of time to open. Can someone please point me in the right direction to have my macro wait until the transaction is finished loading before continuing? Below is the snippet of my code so far.
HTML Code:
Hi billyjo,
You need to add "DoEvents" between your lines giving the OS time to complete.
https://msdn.microsoft.com/en-us/lib.../gg264522.aspx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I'm not sure I understand the context of how to use that function Marvin, can you give me an example such as how I would apply it to the end of my snippet I posted above?
Hi,
In VBA you can do things that the Operating System does, like save a file or open something. If you don't tell VBA to wait until the OS is done, your VBA will fire stuff before the OS is ready to receive the information.
In VBA if you have:
File.Open
File.Open
If is safer to do a:
File.Open
DoEvents
File.Open
The "DoEvents" tells VBA to wait until the OS is done before trying to do the next step. The idea is that with Windows, all those programs that are in memory need service. Windows goes around asking if they need CPU time. DoEvents waits for the CPU to get back to your VBA code before sending the next command.
Worked like a charm. Thanks Marvin!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks