| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mapping the macro path
Thanks Bob! Will e-mail you now.
"Bob Phillips" wrote: Daniel, I have some code that adds a procedure name to all procedures, it could easily be adapted to write a trace statement in the procedure instead. Drop me an email offline, saying whether you want it to write to the debug window (may overflow quickly), a spreadsheet, a text file or whatever, and I will knock you up a little prototype. BTW, that will teach you to employ more proficient coders <g. -- __________________________________ HTH Bob "Daniel Bonallack" wrote in message ... Is there a tool to map the path a macro takes through all it's procedures? I have done a particularly ugly job of creating a macro-intensive spreadsheet over the past 3 years. In fact, I challenge you to think of a single VBA-Best-Practive that I have competently implemented in this spreadsheet. Truly, I should be sent to Notepad and told to stay there for the rest of my life. I would have gotten away with my abuse, but now I have to share the spreadsheet with a more proficient programmer. But perhaps you can help. Is there a tool that will map the complex paths taken by the various procedures when the start button is pushed? Or, failing that, is there a single line of code that I can copy to every procedure that will return the procedure name to a cell as it runs? Something like: Sheets("MapPath").Range("A1").end(xlDown).offset(1 ,0).value = CurrentMacro.Name Any help appreciated. regards Daniel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 questions: Macro Mapping & Active Chart | Excel Programming | |||
| path xml mapping | Excel Programming | |||
| Macro to copy columns from 1st sheet to 2nd according to mapping-p | Excel Programming | |||
| Mapping macro | Excel Programming | |||
| Mapping a drive through a macro | Excel Programming | |||
Threaded Mode
