VBA to create file path

[Mouses]

Hi Guys, hoping you can help because I'm going out of my mind here. I have a pivot which is pulling a file path field through, and of course it doesn't come through as a hyperlink. Every example of converting text to hyperlink that I can find seems to assume that my path start with http. It doesn't. It starts with \\fmu. Can someone PLEASE help me
Out because I actually have no idea what I'm writing. I just copy it and hope for the best. My pivot is PivotTable1, in sheet 2 (named FIRE) and the field that had the now Plai text that I need to be a hyperlink is (unsurprisingly) called Hyperlink.

I have hit alt-F11, and double clicked on sheet 2 ..... And now I'm saying my prayers.

Please can a boffin help??

[Steveapa]

Try using "<" at the front of the string and ">" at the end. Don't know, but it has helped me in the past (but not in vba). Easy to try it.

[skywriter]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic