![]() ![]() This can be beneficial to other community members reading this thread. ![]() Tip: To view, you may first need to first download and install the free Adobe Acrobat Reader DC software. Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. Download our free Office for Mac Quick Starts to get up and running quickly. You could upload into OneDrive and share the link here. MsgBox "Update failed, please check if the new path exist"įunction checkFolderExist(ByVal folderPath As String) As Boolean Set fso = CreateObject("Scripting.FileSystemObject") If (fso.FolderExists(folderPath)) Then checkFolderExist = True Else checkFolderExist = False End If End Functionīesides, I suggest you share with us the file which its hyperlinks need to update. You could test the following code and you need to change the newAddress based on your rule.įor Each h In Worksheets("Sheet1").Hyperlinks
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |