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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Run-time error '3192' 1
Create an Access Table from an Access Query 2
SQL Server thread issue and long running query 3
Sharing Access 7
Excel TWO Instances of Excel One watching Other 3
Auto run query or macro 1
Msaccess.exe Running in the Task Manager 2

Back
Top