Submitted by JXB on Mon, 09/01/2014 - 00:37
Forums:
To all,
I am looking at a task which required a lengthy journal (quite a few "steps" in the process albeit quite simple). I have tried recording the whole operation in 1-go but the journal is a bit too long and any minor changes can have a knock-on effect.
I have therefore tried recording different journals so that;
1. I can understand quickly just the bit I have recorded (as I know it only does 1 thing)
2. can do minor edits to the journal
I was then hoping to "merge" the journal into a final one (a simple copy-and-paste) but I get the error msg about a variable (Dim definition) already existing (which is fair enough). Is there am easy way around this issue?
Thanks
Regards
JXB
re: merging journals
I often use the same strategy of recording multiple small journals and merging them. However, I don't know of a quick & simple process that works for every situation. Sometimes I need the 'duplicated' variables to refer to the same variable. In this case you can simply delete the 2nd (3rd, 4th, etc) "Dim" reference and keep the lines that use the variable values. However, if you need the new 'duplicated' value to refer to a new variable, you'll need to rename the variable either before or after you merge the journals. Personally, I use notepad++ to clean up the recorded journal before merging (delete unnecessary lines of code and rename variables as necessary) as it has excellent search & replace capabilities as well as code highlighting and a 'bookmark' option that I use quite often.