HI All Have an issue with when i create PDF's via VBA when the excel cell contains a hyperlink which points to a sharepoint location. If i click the cell directly in the excel file it links perfectly to the document in the sharepoint directory , but when i create the PDF, it changes the link So the excel file address is https://companyname.com/:p/r/sites But when i view the created PDF it changes it to file:///C:/:p:/r/sites If i link to a normal www. site, no issues at all and the link works fine in the PDF. I've done a lot of searching for this and tweaking of the VBA , but i dont seem to be able to correct this I have the creation set in the vba as xSht.ExportAsFixedFormat _ Type:=xlTypePDF, _ FileName:=xFolder, _ Quality:=xlQualityStandard, _ includedocproperties:=True, _ ignoreprintareas:=False, _ openafterpublish:=False Any suggestions please?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

PDF Hyperlink issue

Thread starter hcabs99
Start date Jan 22, 2021

hcabs99

Active Member

Jan 22, 2021

HI All

Have an issue with when i create PDF's via VBA when the excel cell contains a hyperlink which points to a sharepoint location.
If i click the cell directly in the excel file it links perfectly to the document in the sharepoint directory , but when i create the PDF, it changes the link

So the excel file address is https://companyname.com/:p/r/sites
But when i view the created PDF it changes it to file:///C:/

:/r/sites

If i link to a normal www. site, no issues at all and the link works fine in the PDF.

I've done a lot of searching for this and tweaking of the VBA , but i dont seem to be able to correct this

I have the creation set in the vba as

xSht.ExportAsFixedFormat _

Type:=xlTypePDF, _

FileName:=xFolder, _

Quality:=xlQualityStandard, _

includedocproperties:=True, _

ignoreprintareas:=False, _

openafterpublish:=False

Any suggestions please?