| | |
debugging word 2003 vba macros
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
![]() |
•
•
Join Date: Sep 2007
Posts: 12
Reputation:
Solved Threads: 0
This is pertaining to debugging VBA macros for Word 2003. I am debugging a document with a LOT of buttons which launch macros. If I place a breakpoint in a subroutine, and execute the macro by running it from the VBE debugger, execution stops at the breakpoint. But is there a way to have the VBE debugger launched as soon as I call a macro from a document even if VBE is not open, e.g. if buttons a, b, c, ... z launch macros then I want to open the document, click on a, b, or c, ... z and have the appropriate macro code for a, b, ... appear in the VB Editor window. The only way I could think of is putting a divide by zero error at the beginning of each macro, and selecting debug when the error msgbox pops up. One problem is I'm not even sure which macros are being run by each button because there are so many template files/macro names, and some of the macro names are the same in different templates. It would be so much easier if I could specify that any macro being run should automatically pop up in the VBE.
![]() |
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Elow nid Help here
- Next Thread: Code to monitor port 135 on windows OS
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows





