如何使用vba访问具有不同凭据的网络Excel文件？

I've created VBA code so that a group of people in our company can "stamp" a word document with a unique number stored in an Excel sheet on a network drive (essentially giving a serial#). These people do not have access to said network drive, but I'd like them to be able to execute the VBA code.I've created VBA code so that a group of people