Running macros one line at a time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way we can run a macro one line at a time??? We have a macro
that is accessing SQL Server Tables and we are running into some performance
issues. Is there any way we can run this macro one line at a time to see
where the problem might be???

Thanks in advance.

wnfisba
 
No, you can't. The very fact that you can't is why people are
encouraged to drop Access macros and write equivalent VBA code (that
VBA code is what's called a macro in all other MS Office
applications).

With code you can do lots of intelligent error handling and you can
use the debugger to step through code a line at a time.

HTH
 
Back
Top