VBA code to autosave PDF in BOX folder by multiple users

[Mochi_Mochi]

Hello!
I want others to save PDF file in the shared BOX file.
Here is my code but it doesn't work. I tried a few possible coding but I'm stuck now.
My user ID was Mochi. I use Excel 2016

I can use this and save PDF in the shared BOX folder. However others couldn't.
Appreciate if anyone can help me!


Sub SaveAsPDF()

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\Mochi\Box\Department\Procurement\" & Range("B3").Value _

, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _

:=False, OpenAfterPublish:=True

End Sub
"

 

[Trixterz]

Find the network shared address to that folder and replace it with the local folder address.

 

[Mochi_Mochi]

Find the network shared address to that folder and replace it with the local folder address.

Thank you so much Trixterz!