Change Link Macro (being used twice) is changing output to an incorrect path

**Welrod** · 03-25-2013, 02:45 PM

The following code has been giving me trouble for a day or so, and figured since I feel this a rather unique problem that I should probably get started posting.

Please Login or Register  to view this content.

This is just a snippet of a macro I've been modifying. The macro asks for a user input range("job"), then changes paths of existing links based off this input.

	link prior to input	link post input	correct link post input
link to WB 1	12345prgm1.xlsx	22345prgm2.xlsx	22345prgm1.xlsx
link to WB 2	12345prgm2.xlsx	12345prgm2.xlsx	22345prgm2.xlsx

It should be noted that the actual of link 1 first changes to the proper link (pre the help message), then changes to a 'prgm2' version (after the help message).
But why does it change to 'prgm2' at all?

Also the second link doesn't even change! Why?

Thanks a lot!