JimGunther
Board Regular
- Joined
- Oct 22, 2006
- Messages
- 57
I noticed that my hyperlinks which were working fine when my document was in WORD or Web Page format no longer worked after they were saved as an EXCEL document.
Apparently, EXCEL has taken each occurance of "&" in my hyperlinks and appended "amp;" to the address. (i.e. "&ID=" becomes "&ID="
Is there any simple way to either suppress this extra stuff upon conversion from Web Page to EXCEL or editing the underlying link in a "find and replace mode" after it has become an EXCEL file.
BTW: Thanks to Erik and Norie who helped yesterday. It is clear to me that I'm not proficient enough to be fooling around with VBE.
TIA, Jim
Apparently, EXCEL has taken each occurance of "&" in my hyperlinks and appended "amp;" to the address. (i.e. "&ID=" becomes "&ID="
Is there any simple way to either suppress this extra stuff upon conversion from Web Page to EXCEL or editing the underlying link in a "find and replace mode" after it has become an EXCEL file.
BTW: Thanks to Erik and Norie who helped yesterday. It is clear to me that I'm not proficient enough to be fooling around with VBE.
TIA, Jim