Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the links in Excel at one batch?
Hi all, Good day! Please help me with the following issue: How do I do the following in Excel? Suppose in an Excel sheet there are lots of links, linking the cell to other sheets, There are millions of such links, how do I change the links to another sheet name at one batch? I hope there is a "Find/Replace" for these links? Thanks a lot! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the links in Excel at one batch?
Saved from a previous post:
If you used Insert|Hyperlink, then you've noticed that edit|replace won't touch those hyperlink addresses. If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But the good news is David McRitchie has done most of it for you: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) LunaMoon wrote: Hi all, Good day! Please help me with the following issue: How do I do the following in Excel? Suppose in an Excel sheet there are lots of links, linking the cell to other sheets, There are millions of such links, how do I change the links to another sheet name at one batch? I hope there is a "Find/Replace" for these links? Thanks a lot! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change input in batch | Excel Discussion (Misc queries) | |||
run batch job from each row - how to insert run batch function per row? | Excel Discussion (Misc queries) | |||
links in excel change destination after sort | Excel Worksheet Functions | |||
Batch change | Excel Discussion (Misc queries) | |||
How do I change my default browser from MS Excel 2002. Links cur. | Excel Discussion (Misc queries) |