AnotherAlan
Technical User
Hi,
I have a piece of code I'm using to save a workbook to a sharepoint site. Although it is working as expected I have found that after using the Sub it breaks hyperlinks that I have embedded in other cells. I have seen from t'internet that there are some bugs around hyperlinks but was interested if anyone had come across, and solved, the same problem. I was thinking that if I hard coded the hyperlinks, that might work...but I'm not sure how to do it.
Any ideas?
I have a piece of code I'm using to save a workbook to a sharepoint site. Although it is working as expected I have found that after using the Sub it breaks hyperlinks that I have embedded in other cells. I have seen from t'internet that there are some bugs around hyperlinks but was interested if anyone had come across, and solved, the same problem. I was thinking that if I hard coded the hyperlinks, that might work...but I'm not sure how to do it.
Any ideas?
Code:
ActiveWorkbook.saveas Filename:= _
"[URL unfurl="true"]http://test.test.com/ykl0/C06_9407-ficfp/support-teams/FX/Status[/URL] + Handover/FXStatus_Summary for " + VBA.Strings.Format(Now, "dd mmmm yyyy") + ".xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False