Hello,
I currently have a line that exports to a shared folder. How can I substitute 'Washington' so that any users that have remote access to a PC can run this macro? I heard a suggestion of using a wildcard or ampersand but don't know if or how that would work.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, QueryName, "C:\Users\washington\Shared Folder\ " & " .xlsx", True
Thanks in advance.
I currently have a line that exports to a shared folder. How can I substitute 'Washington' so that any users that have remote access to a PC can run this macro? I heard a suggestion of using a wildcard or ampersand but don't know if or how that would work.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, QueryName, "C:\Users\washington\Shared Folder\ " & " .xlsx", True
Thanks in advance.