Hi Guys,
I am trying to save a file to a onedrive location in a multi user environment, all users have a folder, invoices, that is a sharepoint folder added to file explorer.
My Code is:
I had thought that the windows variable %OneDrive% would add that part of the path, but rather than:Code:StrFileName = Me.CustName & "_" & "invoice" & "_" & Me.invoice & ".pdf" StrFileName = "%OneDrive%\Invoices\" & StrFileName
{C:}\{Users}\{user}\{OneDrive}\Invoices\filename.p df
I am getting:
%OneDrive%\Invoices\customer_invoice_65609.pdf
Thanks in advance