One drive not in same folder in all PC's

I have three PCs on a local Lan all using Win 10 Pro with OneDrive enabled in all three machines in different directories. My problem is as follows:

I have an Excel program which has a filename in it as C:\OneDrive\Statement\xxx.csv which is the source of the data. This will only work if the OneDrive folder is in the C:\ directory. If I change it to be my OneDrive directory default C:\Users\Directory\nmcil\OneDrive. My other two machines does not have this directory on their machines and the programs fails on "cannot find file" 

How can I address the Program to accept OneDrive in all three locations, when OneDrive default is different on three systems?

Any assistance would be appreciated.

Regards