Thank you to Paul and Hafizullah!
I'm using Excel 2010 and windows 7.
I have never been aware of this "helpfullness" by Excel/Windows trying to understand what we "are not doing"!!?
And I suspect that you have pointed on the problem.
After some trying and failing I have given it up, I was not able to adjust how excel handled the pauses. .
I thought perhaps using the API sleep function in Windows could solve the problem, but NO. Putting in SLEEP-pauses for more than a second or two makes EXcel hang.
So far I've figured ou that application.wait causes no problems, but it can not make pauses for less than a second.
Thank you again!
[Non-text portions of this message have been removed]
__._,_.___
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
.
__,_._,___
Tidak ada komentar:
Posting Komentar