Refactoring/Debugging code

[CMIIandExcel]

Hi all

I have built up a bundle of code which i am trying to refactor and tidy up a bit.

In the editor is there a way to see where a procedure is called by looking at the procedure, other than setting breakpoints and running all the main procedures.

Any other tips or points to good articals on using the editor would be welcome.

Thanks in advance

Mike

 

[Zack Barresse]

Hi there,

Take a look at the CallTree from Stephen Bullen's page here...

http://www.oaltd.co.uk/Excel/Default.htm

I think that will get you what you're looking for, without knowing any other data.

 

[Richard Schollar]

Ahh - that's useful to me as I have an Access db of Functions where I need to understand how they are used. Presumably I can modify to work in Access (shouldn't be difficult as only the one db).

Unfortunately, Access lets UDFs be used in SQL statements, so I assume I will have to trawl thru the query defs manually?

Thanks Zack!!!

 

[CMIIandExcel]

Zack

Thanks for the link, it would be just what i need but it doesnt seem to work on my excel

I get the Added option in my menus, when I click on it it displays the pick a workbook dialog but the are no workbooks listed to pick from.

I am running Excel 2003, any ideas why its failing ?

Regards

Mike

 

[Zack Barresse]

@Mike: Are all of the workbooks saved?

@Richard: I'm not that good with Access to know. I would think, off the top of my head, you could put the SQL statements into textual format and do a search on it, maybe using a text file and EOF-type iteration? Or even solely via VBA w/ InStr()? Dunno!