I am trying to install a Word 2016 template I developed onto my wife's PC. I copy a file that the template references to her local "C:\Users\(username)\Documents" folder. But when I try to reference that file using that path
Code:
strRosterPath = "C:\Users\" & Environ("username") & "\Documents\Roster.csv"
, it fails. Further investigation finds that the file is
not on her local drive at all
but on a
OneDrive path and with a different Environ("username").
An internet search confirms that: "In Windows 10, OneDrive is the default save location for your files and documents." (
Turn off, disable, or uninstall OneDrive - Knowledgebase - Pen Publishing Interactive, Inc.).
Yet on my PC running windows 10, my files stay where I put them (which is not on OneDrive).
Reconfiguring her machine is not an option. So I'm left with the smelly option of hard-coding that OneDrive path into my template after installing the word .dotm on her machine.
I've confirmed that option works. But isn't there an option that doesn't require hard-coding?
Wife is running Office 365, I'm running Office 2016.
Specifically, I'm running Microsoft Windows 10 Home Build 19044 on a Dell Inspiron 15-3567 using Microsoft Word 2016 MSO (Version 2209 Build 16.0.15629.20196) 32-bit.
Wife's machine running Microsoft Windows 10 Home Build 19043 on an Acer Aspire TC-885 using Microsoft Word 365 MSO (Version 2209 Build 16.0.15629.20200) 64-bit.