é¦å
æå¼ä½ çexcelï¼åå»å·¥å
·--å®--å®å
¨æ§--éæ©ä½ãç¶åä¿åéåºexcelã
å次æå¼ä½ çexcelè¡¨æ ¼ï¼å³é®åå»ä½ ç表å--æ¥ç代ç ï¼ç¶åè¾å
¥ï¼
Sub aa()
For Each c In ActiveSheet.Hyperlinks
c.Address = Replace(c.Address, "C:\program files\èµæ", "E:\èµæ")
Next
End Sub
å
³éVBEï¼åå°Excelï¼æALT+F8ï¼å¼¹åºå®çªå£ãéæ© ä½ ç表å.aa ï¼ç¹å»æ§è¡å³å¯ã
追é®è¯äºåï¼ä¸ºä»ä¹æ²¡ç¨å¢ï¼è¶
é¾æ¥è¿æ¯æ²¡æååï¼æçæ¯office 2003