Good day, I have a situation whereby when btn_Finished is clicked it should export “Statement_file” to one of the existing subfolders with “USERS” names “fld_Abi”, “fld_Clint”, “fld_Dell”, “fld_Many”, “fld_More” and “fld_TEMPFolder”(Not assigned to any user). All the subfolders resides in a folder named “FLD_ReportPickup” and are all named after each user except the “fld_TEMPFolder” which is to be used only when a user name is not setup or does not exist in the folder “FLD_ReportPickup“.

This is what I have tried:

Dim User As String
Dim TempDAPath
Dim DAPath

If USER = “” Or IsNull(User) Then
USER = “fld_TEMPFolder”

DAPath = “W:Service CenterReportsDealershipsDealershipsONLY*PROCESSORS*”
‘(Statement_file is correctly autosaved here in the “PROCESSORS” subfolder)

TempDAPath =”W:ServiceCenterReportsDealershipsDealershipsONLYPROCESSORSFLD_ReportPickup” & USER & ”
‘(Statement_file is NEITHER saving in any user’s subfolder NOR in the designated “fld_TempFolder”)

End If

I need the btn_Finished to save Statement_File to respective USER‘s subfolder, and in the case of a new user that has not been setup, and/or a subfolder that does not exist saved in “fld_TEMPFolder”.