I had to tweak it a little bit, but the reply got me in the right direction of the "if iCount MOD 14". Here is the final code that worked for me. Thanks for your help!!!
iMaximum = 100
iCount = 1
Do while iCount < UBound(BLANKLoad)+1
autECLSession.autECLOIA.WaitForAppAvailable...
Hello,
I'm OK with VBA in Excel and play a bit with the macros that upload excel data in our ERP system. I've come across one that I'm hoping someone can offer some advice. We have a spreadsheet to upload inventory after a stock take. Our ERP system has a set of keystrokes to enter the data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.