'Exporting' contents of Locals Window

[mynci]

Hi,

This one has me a little stumped. I have been making some changes to a VBA application in excel and somewhere along the line a variable contains the wrong value. For various reasons it is not trivial to trace the variable or variables. What i want to be able to do is copy the entire contents of the locals window including all the expanced arrays etc to another program (possibly excel) and then i can compare them with the original program at the same point in execution and spot the differences.

is this possible? if not i will have to write a windows automation tool to copy and paste a line at a time!

Many Thanks
Stephen

[Andy Pope]

Can you not set a watch to halt the program when the value changes?

I'm not aware of anything that dumps variable information to a file.

[mynci]

Hi Andy,

A watch would only let me watch one variable (i can add many), essentially i want to stop the program at a particular point in execution, get a 'map' of every variable and then repeat the same thing with the previous version of the code. the are many hundreds of variables which are frankly a nightmare to sift through (this is an inherited project, as so many are).

i have written a quick script to 'automate' the copy and paste process from the locals window. however it is not a quick or elegant solution.

Regards
Stephen

[Andy Pope]

You know you can use conditions when setting a watch?

[mynci]

I am aware of this. essentially i am looking to get a complete dump of the variables so that i can compare two files with thousands of variables. since i can only run one copy of VBA at a time (as far as i know) i cannot compare two live windows halted at the same position.

i have written a short script in AutoIT to activate the locals window and copy each item to a file. its a bit slow but it gets me what i need.

thanks again
stephen

[Andy Pope]

Was just checking.

Although you can not run 2 sets of code at once perhaps you can run 2 instances of excel.