Hello All! I need a second set of eyes on this issue. I am getting Run-time error '3044' (invalid path) error. Here is my TransferText statement
Code:
DoCmd.TransferText acExportDelim, , "strExportSQL", strFullPath
Debug.Print strFullPath
I build the strFullPath here:
Code:
strFullPath = strRptPath & "\SerialExport_" & Format(dteNewDate, "MMDDYYYY") & ".csv"
The debug returns this (xxxx is a company name that I redacted, but it is correct):
Code:
D:\xxxxxxx\LE Database\LETrackingSys_v2be\Testing\SerialExport_10032022.csv
The file path copied from file explorer is:
Code:
D:\xxxxxxx\LE Database\LETrackSys_v2be\Testing
For the life of me I cannot see what would be causing this. Any assistance would be greatly appreciated.