[AccessD] Transfer Spreadsheet

[Gustav Brock]

Hi Stuart

No, it is not always necessary. I checked out the offending code, and it worked with no problems right away - given a date string of "20181008".
I assumed slashes had been used which, of course, will doom the code to fail - as already noted by Rocky.

/gustav

_________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Stuart McLachlan <stuart at lexacorp.com.pg>
Sendt: 8. oktober 2018 21:42
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] Transfer Spreadsheet

Yes, the spaces after "...TimeOutput" and "PayPeriod" mean that the whole string needs to
be passed surrounded by double quotes.

 strFileName = """" & "C:\A-Best Systems\TimeOutput " & strDateToday & " PayPeriod "
 & strJobPeriod & ".xlsx" & """"

(Also as pointed out in a previous post, you need to avoid any "/"'s in strDateToday.