View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Different results when running macro vs stepping into macro

If there are any "external" operations which run asynchronously with the VBA
then you may get different results depending on how long those operations
take. For example, automating a web page from VBA without waiting for (eg)
pages to complete loading before trying to interact with them will show this
type of difference.

Tim.


"Ken Steinhoff" wrote in message
...
My boss built a macro which returns different results when run than
when he steps through it.

Before I get specific about what the macro does (since I don't have it
in front of me), I thought I'd ask the general question about what
might cause that to happen.

If the macro works when executed manually step-by-step, I would think
it should work the same way when launched.

Ideas? Comments?

--
Ken Steinhoff
Telecommunications Manager
Palm Beach Newspapers, Inc.

-----------------
www.Newsgroup-Binaries.com - *Completion*Retention*Speed*
Access your favorite newsgroups from home or on the road
-----------------